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_at_tax.state.vt.us> To: <jonathan_at_jlcomp.demon.co.uk>; <Mladen.Gogala_at_aetn.com>; <thomas.mercadante_at_labor.state.ny.us>; <mark.powell_at_eds.com>; <oracle-l_at_freelists.org> 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_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;
:

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