Re: how to find session id/serial no. of current session

From: "S S Wan" <sswan_at_hk.super.net> >> Does anybody know how to find the session id and serial number of the current session? <<

Use the userenv function to get the 'sessionid' and join this to the audsid in  v$session. You may need to modify (fix) the sql but the query is something  like:

select sid, serial#
from v$session
where audsid = userenv('SESSIONID');

Hope this helps.

Mark Powell -- The only advise that counts is the advise that you follow so follow your own advise Received on Sat Oct 04 1997 - 00:00:00 CDT