Re: Session ID determination

From: ls cheng <g-e-n-o_at_europe.com>
Date: 16 Sep 2001 12:08:36 -0700
Message-ID: <b352e1b3.0109161108.13b3aecc@posting.google.com>

this perfomance wise is probaly better

select sid from v$mystat where rownum = 1 /

this is using the userenv

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

"Matteo Vitturi" <mvitturi_at_libero.it> wrote in message news:<eb141852b8b0eae8f3f9a73adbcf4d13.16982_at_mygate.mailgate.org>...
> Hello all!
>
> Is there any simple way to determine the ID of the session
> I am running on?
>
> I know I can select from v$session and look for it, but
> what I'm looking for is something like a pseudocolumn
> so it's easy to be accessed from any PL/SQL or SQL.
>
> Regards.
> Matteo Vitturi
Received on Sun Sep 16 2001 - 14:08:36 CDT