Re: Oracle Sessions

You can also do
SELECT GLOBAL_NAME FROM GLOBAL_NAME;
for the name of the instance you are connected to. This query can be run by any user - no need to have DBA privilege.

For Oracle Scripts, Tips and Links
http://www.geocities.com/SiliconValley/Peaks/4535/oracle_main.htm

Winnie Liu wrote in message <6rt3oa$604_at_dfw-ixnews9.ix.netcom.com>...
>If you just want to know what instance you are connecting to, query the
>v$database table.
>Winnie
>
>proctorh_at_email.exide.com wrote in message
><35e1b2d4.5926101_at_news.mindspring.com>...
>>Is there any way to get information about the sessijon of sqlplus that
>>I am in? Some very kind person posted this query a while ago and I
>>missed saving the thing to my computer.
>>
>>I would really like a way to get the info on my current session
>>without just selecting the v$session table and getting info on
>>everybody elses session. There is one generic DB logon and things can
>>get pretty confusing there.
>>
>>I would also like a way to display which instance that I am under when
>>I log in to sqlplus. Something like: "You are connected to instance
>><instancename>".
>>
>>Any ideas?
>>
>>Thanks in advance.
>>
>>HAP
>
>
Received on Mon Aug 24 1998 - 23:21:16 CDT