Re: How do I get my session ID
From: Gayatri Sriram <gsriram_at_ix.netcom.com>
Date: 1996/11/22
Message-ID: <574dsu$o1j_at_dfw-ixnews2.ix.netcom.com>#1/1
Date: 1996/11/22
Message-ID: <574dsu$o1j_at_dfw-ixnews2.ix.netcom.com>#1/1
In <32948425.1215_at_tomax.com> Fred Blindheim <fredb_at_tomax.com> writes:
>
>I can type the following:
>
> SELECT osuser, sid
> FROM v$session
>
>and get a list of all the current Oracle users and their session id.
>But, how to can I return just MY session id. Can Oracle tell me what
my
>osuser is so I can stick it in the where clause? Or, is there another
>way to do this?
Try this :
SELECT osuser, sid
FROM v$session
where audsi = userenv('SESSIONID')
Received on Fri Nov 22 1996 - 00:00:00 CET