How 2 check host name..

[Kumar_RP]

Hai Friends,
How to check the details which user using different host (service ) names in the server?????

We can find the user name, user id , password from dba_users... But i want to know which is the service name that particular user working...

We are having different domains for working...

Thnx.

Write back 2
palanir@sakinfotech.co.in


R.Palani Kumar.

[marist89]

SQL> l
1* select global_name from global_name
SQL> /

GLOBAL_NAME
-----------------------------------------
NT817.US

[kris109]

If you want the host name of the machine on which oracle instance is running:

select host_name from v$instance;