Thanx a lot Rahul this is the answer i expected.

Ramki

----- Original Message -----
From: "Rahul" <[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Friday, June 28, 2002 2:56 PM
Subject: RE: How to find the current session id which i connected through
SQL PlusHi


> 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 documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to oracledba-[Email Address Removed] To subscribe: send a blank email to oracledba-[Email Address Removed] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these
terms:http://www.lazydba.com/legal.html

Oracle LazyDBA home page