Find the server name for an Oracle database

Question

Is there a way of finding the name of the server an Oracle database is hosted on

User · Answer

If you don t have access to the v  views  as suggested by Quassnoi  there are two alternatives  select utl inaddr get host name from dual   and  select sys context  USERENV   SERVER HOST   from dual   Personally I d tend towards the last as it doesn t require any grants privileges which makes it easier from stored procedures

User · Answer

SELECT  host name FROM    v instance

User · Answer

I use this query in order to retrieve the server name of my Oracle database   SELECT program FROM v session WHERE program LIKE    PMON

User · Answer

The query below demonstrates use of the package and some of the information you can get   select sys context    USERENV    DB NAME    db name  sys context    USERENV    SESSION USER    user name  sys context    USERENV    SERVER HOST    db host  sys context    USERENV    HOST    user host from dual   NOTE  The parameter    SERVER HOST    is available in 10G only   Any Oracle User that can connect to the database can run a query against    dual     No special permissions are required and SYS CONTEXT provides a greater range of application-specific information than    sys v instance

[oracle] Find the server name for an Oracle database

Examples related to oracle