Re: own session's SID
- From: "Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx>
- To: <Mladen.Gogala@xxxxxxxx>, <thomas.mercadante@xxxxxxxxxxxxxxxxx>, <mark.powell@xxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 15 Oct 2004 20:45:36 +0100
select dbms_support.mysid from dual;
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/seminar.html
Optimising Oracle Seminar - schedule updated Sept 19th
----- Original Message -----
From: "Gogala, Mladen" <Mladen.Gogala@xxxxxxxx>
To: <thomas.mercadante@xxxxxxxxxxxxxxxxx>; <mark.powell@xxxxxxx>;
<oracle-l@xxxxxxxxxxxxx>
Sent: Friday, October 15, 2004 8:30 PM
Subject: RE: own session's SID
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
