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

Joseph Weinstein wrote:

>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
>
>
>

Another way is:

   SELECT osuser
   FROM sys.v_$session
   WHERE sid = (

      SELECT sid
      FROM sys.v_$mystat
      WHERE rownum = 1);

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)