Re: How do I get my session ID
From: John Hough <q6y_at_ornl.gov>
Date: 1996/11/21
Message-ID: <5722fh$a89_at_stc06.ctd.ornl.gov>#1/1
Date: 1996/11/21
Message-ID: <5722fh$a89_at_stc06.ctd.ornl.gov>#1/1
Fred:
You can get your session id by issuing the following command:
select userenv('SESSIONID') from dual;
to get this information from v$session
select * from v$session where audsid = usenv('SESSIONID');
This works in 7.1.6 on AIX.
Hope this helps,
John Hough Received on Thu Nov 21 1996 - 00:00:00 CET