RE: own session's SID

Is this a O10g thing? I can't find any object name dbms_support in my 9.2.0.4 database.

Ruth

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Jonathan Lewis Sent: Friday, October 15, 2004 3:46 PM
To: Mladen.Gogala_at_aetn.com; thomas.mercadante_at_labor.state.ny.us; mark.powell_at_eds.com; oracle-l_at_freelists.org Subject: Re: own session's SID

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_at_aetn.com> To: <thomas.mercadante_at_labor.state.ny.us>; <mark.powell_at_eds.com>; <oracle-l_at_freelists.org> 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_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


--
http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l