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