Commands to get oracle server info.

jjk

Hello everybody,
Could anybody tell me the commands that can get us various server details
(like server version etc etc ...) or how can we get the server environment details ?

Etbin

http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/functions165.htm#i1038176

Regards

Etbin

105967

I'm since longer time no more in the dba side of Oracle, but a starting point for you could be the tables v$banner, v$parameter. In the server reference manual | [http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/toc.htm] there are a lot more of these dynamic performance views.

For more and more accurate information you'd better write this question in the [database server forum | http://forums.oracle.com/forums/forum.jspa?forumID=61]

Rob van Wijk

In addition you can issue these statements:

select platform_name from v$database

or for some Oracle versions as well as the platform:

select * from v$version

Regards,
Rob.