Re: What's the V$SESSION query to locate your specific session?

Anurag Varma wrote:

> "Joseph Weinstein" <bigdog_at_bea.com> wrote in message
> news:3F941AEF.1368D285_at_bea.com...
> > Hi, and thanks in advance.
> > How can I tell what row in V$SESSIONS corresponds to my
> > current connection?
> > I would like to make several concurrent connections to the DBMS,
> > using the same user/password, from the same application, and I would
> > like to retain info that identifies these connections at the DBMS, so if
> > one connection is closed, another connection can know exactly which
> > one of my application connections went away by querying the DBMS.
> >
> > thanks,
> > Joe Weinstein
> >
>
> select * from v$session where audsid = sys_context('USERENV','SESSIONID')
>
> or in older versions
>
> select * from v$session where audsid = userenv('SESSIONID');
>
> Anurag

Thank you very much!
Joe Received on Mon Oct 20 2003 - 13:17:17 CDT