Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: own session's SID

RE: own session's SID

From: Ruth Gramolini <rgramolini_at_tax.state.vt.us>
Date: Fri, 15 Oct 2004 16:36:57 -0400
Message-ID: <01cc01c4b2f6$b6bc28e0$8459000a@vttaxnet.tax.state.vt.us>


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

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
Received on Fri Oct 15 2004 - 15:32:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US