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_at_labor.state.ny.us]
> Sent: Friday, October 15, 2004 3:20 PM
> To: 'mark.powell_at_eds.com'; oracle-l_at_freelists.org
> Subject: RE: own session's SID
>
>
> Or you can...
>
> SELECT sid
> FROM v$session
> WHERE audsid = sys_context('userenv','sessionid')
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Oct 15 2004 - 14:26:09 CDT
