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 query to ID the specific DBMS session?

Re: what query to ID the specific DBMS session?

From: <joeNOSPAM_at_BEA.com>
Date: 2 May 2007 13:37:50 -0700
Message-ID: <1178138270.939931.66190@l77g2000hsb.googlegroups.com>


On May 2, 1:19 pm, "Michel Cadot" <micadot{at}altern{dot}org> wrote:
> "joeNOS..._at_BEA.com" <joe.weinst..._at_gmail.com> a écrit dans le message de news:
> 1178136264.220504.27..._at_c35g2000hsg.googlegroups.com...
> | Hi all,
> | This is a real basic Oracle ignorance of mine... What query can I
> | run
> | to get the unique ID of the current DBMS session, so if there's 100
> | sessions, all logged in as scott/tiger, each one has it's own
> | different
> | ID?
> | thanks
> | Joe Weinstein at BEA Systems
> |
>
> v$session
>
> Regards
> Michel Cadot

Thanks. "select * from v$session" gives many rows. What qualifier should I give to get only the row corresponding to my session? Received on Wed May 02 2007 - 15:37:50 CDT

Original text of this message

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