Toad World® Forums

Physical Server Name


Is there any way that SQL Navigator can tell me what physical server name a database sits on??? Or is there an Oracle SQL script that will do so???

Thanks in advance for your review and hopeful for a response.



In Windows, open up a DOS Command Prompt Window (Start->Run->Cmd)
Type tnsping followed by the database name and press enter. Resulting text will indicate a HOST= which is the servername.

c:>tnsping xxdev

TNS Ping Utility for 32-bit Windows: Version - Production on 22-JUL-2009 13:05:54

Copyright © 1997 Oracle Corporation. All rights reserved.

Used parameter files:
C:\Program Files\odbc9210\network\admin\sqlnet.ora

Used ONAMES adapter to resolve the alias
OK (0 msec)


sys_context(‘USERENV’, ‘OS_USER’) osuser,

sys_context(‘USERENV’, ‘HOST’) machine,

from dual;

If you are looking for an oracle way to see what system we do something like this. I think it only works on 8 or higher… There may be others…

select****sys_context(‘USERENV’, ‘TERMINAL’) terminal,sys_context(‘USERENV’, ‘SESSION_USER’) sess_user



You can get this information from Session Browser(Tools -> Session Browser). Select your session and looking for “TERMINAL” in Session tab.

Hope this help.