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: Michel Cadot <micadot{at}altern{dot}org>
Date: Wed, 2 May 2007 22:19:35 +0200
Message-ID: <4638f257$0$7500$426a34cc@news.free.fr>

"joeNOSPAM_at_BEA.com" <joe.weinstein_at_gmail.com> a écrit dans le message de news: 1178136264.220504.27540_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 Received on Wed May 02 2007 - 15:19:35 CDT

Original text of this message

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