Re: own session's SID

I think it first appeared with 8.1
But it isn't installed by default

Check $ORACLE_HOME/rdbms/admin/dbmssupp.sql.

In it just opens a cursor on
    select sid from v$mystat;


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: "Ruth Gramolini" <rgramolini@xxxxxxxxxxxxxxx>
To: <jonathan@xxxxxxxxxxxxxxxxxx>; <Mladen.Gogala@xxxxxxxx>;
<thomas.mercadante@xxxxxxxxxxxxxxxxx>; <mark.powell@xxxxxxx>;
<oracle-l@xxxxxxxxxxxxx>
Sent: Friday, October 15, 2004 9:36 PM
Subject: 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@xxxxxxxxxxxxx
: [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Jonathan Lewis
: Sent: Friday, October 15, 2004 3:46 PM
: To: Mladen.Gogala@xxxxxxxx; thomas.mercadante@xxxxxxxxxxxxxxxxx;
: mark.powell@xxxxxxx; oracle-l@xxxxxxxxxxxxx
: Subject: Re: own session's SID
:
:
:
: select dbms_support.mysid from dual;
:


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

Other related posts: