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 -> Current Session ID (SID) v$session

Current Session ID (SID) v$session

From: <creas002_at_mc.duke.edu>
Date: Mon, 03 Aug 1998 21:20:14 GMT
Message-ID: <35c62843.963119462@143.186.15.78>


Help!!!

  I'm trying to find a way that I can identify my current session (SID) in v$session.

I have tried joining v$session with user_users, but I can only ensure my username is correct, but if I have multible sessions running from different terminals and/or applications I will get multiple rows. I need to be able to identify the unique SID, TERMINAL, APPLICATION for the current session.

Any help is greatly appreciated. Received on Mon Aug 03 1998 - 16:20:14 CDT

Original text of this message

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