Forum Stats

  • 3,734,273 Users
  • 2,246,935 Discussions
  • 7,857,216 Comments

Discussions

Commands to get oracle server info.

jjk
jjk Member Posts: 354
edited Sep 11, 2008 4:12AM in SQL & PL/SQL
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 ?
Tagged:

Answers

  • Etbin
    Etbin Member Posts: 8,968 Gold Crown
    http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/functions165.htm#i1038176

    Regards

    Etbin
    Etbin
  • 105967
    105967 Member Posts: 1,027
    edited Sep 11, 2008 4:11AM
    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]
    105967
  • Rob van Wijk
    Rob van Wijk Member Posts: 5,856 Bronze Trophy
    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.
    Rob van Wijk
This discussion has been closed.