Re: Please Help: How do I get my current session id?

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Thu, 5 Aug 1999 21:53:04 +0200
Message-ID: <933882787.11022.0.pluto.d4ee154e@news.demon.nl>

select sid from v$session where audsid = userenv('sessionid')

As far as I know the audsid is determined regardless the auditing state.

Hth,

Sybrand Bakker, Oracle DBA

Justin J. Risser <JJRisser_at_lancasterlabs.com> wrote in message news:10907816B00AD211A93300A0C9B3BBE602146A2B_at_xdelta.lancasterlabs.com...
> Is there a way to get my current session id? I know about the V$SESSION
> view and all, but that has a row for every user. How do I know which
> row is mine, and what my session id is? I have thought about using the
> USERENV('SESSIONID'), but that is the auditing session id, and the DBA
> wants to turn off auditing so then I will not have access to it. Any
> information would be greatly appreciated. Thank you.
>
> Justin
>
Received on Thu Aug 05 1999 - 14:53:04 CDT