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

"Rene Nyffenegger" <rene.nyffenegger_at_gmx.ch> wrote in message news:bn1g1a$s7ooh$1_at_ID-82536.news.uni-berlin.de...
>
> > 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.
>
>
> Yet another possiblity, if dbms_support is installed:
>
> select * from v$session where sid=sys.dbms_support.mysid;
>
> Rene
>
>
>
> --
> Rene Nyffenegger
> http://www.adp-gmbh.ch

An interesting note:
dbms_support.mysid function call does exactly what Daniel notes as the solution (select sid from v$mystat where rownum = 1).

Anurag Received on Mon Oct 20 2003 - 15:40:04 CDT