Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: What's the V$SESSION query to locate your specific session?

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

From: Anurag Varma <avarmadba.skipthis_at_yahoo.com>
Date: Mon, 20 Oct 2003 18:07:56 GMT
Message-ID: <0wVkb.7864$Fc5.3399@nwrdny01.gnilink.net>

"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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US