Re: Q: How to obtain SID for my session?
From: Robert Nilsson <roni_at_monet.no>
Date: Sat, 1 Sep 2001 14:46:42 +0200
Message-ID: <9mqlek$g89$1_at_oslo-nntp.eunet.no>
Date: Sat, 1 Sep 2001 14:46:42 +0200
Message-ID: <9mqlek$g89$1_at_oslo-nntp.eunet.no>
It even easier!!!
select sid from v$mystat where rownum = 1
/ Robert
"padderz" <member_at_dbforums.com> wrote in message
news:3b77c4cf$1_at_usenetgateway.com...
> Try...
>
> SELECT sid, serial# FROM v$session WHERE audsid = USERENV('SESSIONID');
>
>
>
> --
> Padderz
> SYSOP, RevealNet PL/SQL Pipeline
> Oracle Developer, Cellular Operations UK
>
> Posted via dBforums
> http://dbforums.com
>
Received on Sat Sep 01 2001 - 14:46:42 CEST