Re: How can I get this info?

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Wed, 1 Dec 1999 23:47:15 +0100
Message-ID: <944088521.27714.0.pluto.d4ee154e@news.demon.nl>

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

Hth,

--
Sybrand Bakker, Oracle DBA
<kshave_at_health.gov.mb.ca> wrote in message news:823v3u$s7t$1_at_nnrp1.deja.com...
> Is it possible to figure out what your current session id is? I know
> it is listed in v$session, but if you are logged in several times then
> there is no definite way to distinguish between the sessions.
>
> Any ideas?
>
> --
> -Keith
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Dec 01 1999 - 16:47:15 CST