Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: What's the V$SESSION query to locate your specific session?
"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 Received on Mon Oct 20 2003 - 13:07:56 CDT