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

Re: Current Session ID (SID) v$session

From: Biju Thomas <bijuthomas_at_email.msn.com>
Date: Tue, 4 Aug 1998 19:55:52 -0500
Message-ID: <#eoDUvAw9GA.156@upnetnews03>

Try this...

select audsid, sid, serial#, username
from v$session
where audsid = userenv('SESSIONID');

--
Thanks,
Biju Thomas

For Oracle Scripts, Tips and Links
http://www.geocities.com/SiliconValley/Peaks/4535/oracle_main.htm Received on Tue Aug 04 1998 - 19:55:52 CDT

This message: [ Message body ]
Next message: Biju Thomas: "Re: How to get my session id?"
Previous message: martin: "Oracle newbie--opening database and listing tables?"
In reply to: creas002_at_mc.duke.edu: "Current Session ID (SID) v$session"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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