RE: own session's SID
- From: "Gogala, Mladen" <Mladen.Gogala@xxxxxxxx>
- To: "'thomas.mercadante@xxxxxxxxxxxxxxxxx'" <thomas.mercadante@xxxxxxxxxxxxxxxxx>, "'mark.powell@xxxxxxx'" <mark.powell@xxxxxxx>, oracle-l@xxxxxxxxxxxxx
- Date: Fri, 15 Oct 2004 15:30:26 -0400
I cannot believe that oracle still didn't create a function
which would return session id and serial#. This question has been
asked ever since Oracle v6 and it is always the same answer:
userenv('AUDSID') (or, equivalent version: SYS_CONTEXT('USERENV','AUDSID'))
How long will it take for them to finally get it? Is there a reason
why we cannot have simple SYS_CONTEXT('USERENV','SID') ?
--
Mladen Gogala
A & E TV Network
Ext. 1216
> -----Original Message-----
> From: Mercadante, Thomas F
> [mailto:thomas.mercadante@xxxxxxxxxxxxxxxxx]
> Sent: Friday, October 15, 2004 3:20 PM
> To: 'mark.powell@xxxxxxx'; oracle-l@xxxxxxxxxxxxx
> Subject: RE: own session's SID
>
>
> Or you can...
>
> SELECT sid
> FROM v$session
> WHERE audsid = sys_context('userenv','sessionid')
--
//www.freelists.org/webpage/oracle-l
Other related posts:
