BUT !!! i'm not sure wether this works if you dont have the auditing on, you
cannot find the SID of ur session using this,
as this will join to the AUDSID coloum of the v$session...



> SQL> select userenv('SESSIONID') FROM DUAL;
>
> USERENV('SESSIONID')
> --------------------
> 4522740
>
>
> ----------
> From: ramki[SMTP:[Email Address Removed] Sent: Friday, June 28, 2002 4:23 PM
> To: LazyDBA.com Discussion
> Subject: How to find the current session id which i
> connected through SQL PlusHi
>
> Hi All,
>
> will any one tell me how to find the current session id which i
> connected through SQL Plus.
>
> Thanx in advance
> Ramki
>
>
>
>
>
>
Oracle LazyDBA home page