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

> 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