Re: Getting own session id

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2000/05/27
Message-ID: <959402096.1530.0.pluto.d4ee154e@news.demon.nl>#1/1

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

Hth,

Sybrand Bakker, Oracle DBA

Hello <hello_at_hello.world> schreef in berichtnieuws 8gmve6$97i$1_at_news.xmission.com...
> Is there any way to find out the session id or serial# for the current
> session, v$session is fine but I don't know of a way to identify the
current
> session itself, most of the times it is a lucky guess.
>
> Thanks
>
>
>
Received on Sat May 27 2000 - 00:00:00 CDT