Re: Current Session Identifier

Dan,

try using the following code:

SELECT sid
  FROM v$session
 WHERE userenv('SESSIONID') = audsid;

Hope this helps.

--
Vikram Goel                                 Motorola email: vgoel_at_pts.mot.com
Sr. Oracle DBA - Consultant
Aerotek Inc.                                My email:  vgoel_at_emi.net

Motorola Info:
Mail Stop 39, Room S1014
1500 Gateway Blvd,
Boynton Beach, FL 33426 

In article <31B5D095.1965_at_mail.stil.scitex.com>, Dan Wities <dan_wities_at_mail.stil.scitex.com> writes:


>Is there an easy way for an Oracle user to know his/her current session 


>ID?  I can see ALL of the session ids in the V$SESSION table, but how can 

>I determine which one belongs to my current session?