Re: own session's SID

From: David Fenng <dbanotes_at_gmail.com>
Date: Mon, 25 Oct 2004 18:48:58 +0800
Message-ID: <6622a16f0410250348cf3d94f@mail.gmail.com>

first appeared with Oracle 7.2 ?

SQL> select dbms_support.package_version from dual;

PACKAGE_VERSION

---

DBMS_SUPPORT Version 1.0 (17-Aug-1998) - Requires Oracle 7.2 - 8.0.5

On Fri, 15 Oct 2004 21:36:36 +0100, Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk> wrote:
>
> 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
>

-- 
David Fenng
http://www.dbanotes.net 
some articles about Oracle RDBMS 8i/9i/10g (in Chinese)
--
http://www.freelists.org/webpage/oracle-l

Received on Mon Oct 25 2004 - 05:44:39 CDT