Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: get sid (session id) and serial#?

Re: get sid (session id) and serial#?

From: Arup Nanda <>
Date: Mon, 01 Sep 2003 08:24:25 -0800
Message-ID: <>

MessageOracle _officialy_doesn't support it even now. It is included in the sources with a caveat that it will be installed only under instructions from the Support Analysts only. That is why the package is not installed as a part of a normal installation.

Think of it this way - even if it was not included "by mistake" in 8.1.5, there were two releases of 8i after that, 8.1.6 and 8.1.7, not to mention several patchkits. The mistake could have been easily fixed by including the source. However, that was not done. Similarly, if it was a mistake, Oracle support should have been more than happy to send out the source upon request; but they weren't.

HTH. Arup

  It is my understanding that Oracle do support the dbms_support package and that it should have been in the 8i distribution, but was missed out by mistake. It's calls to sys.dbms_system.set_ev they do not supoprt since this enables you to set any debug event in the kernel.


    -----Original Message-----
    From: Arup Nanda []     Sent: 30 August 2003 00:30
    To: Multiple recipients of list ORACLE-L     Subject: Re: get sid (session id) and serial#?

    Oracle officially "desupported" the package in 8i; but then included (by mistake?) in 9i. In 8i, however, you could pester your friendly neuighborhood Support Analyst to give you the package. You could try from 9i sources, too; but not sure if they work.


      It's not in 8.1.5

      Igor Neyman, OCP DBA

      -----Original Message-----
      From: [] On Behalf Of John Kanagaraj
      Sent: Friday, August 29, 2003 3:20 PM
      To: Multiple recipients of list ORACLE-L
      Subject: RE: get sid (session id) and serial#?

      Need to install @?/rdbms/admin/dbmssupp while connected as SYS. Available on all platforms 8.0.6+ I understand.

      John Kanagaraj
      DB Soft Inc
      Phone: 408-970-7002 (W)

      Disappointment is inevitable, but Discouragement is optional!

      ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers **

        -----Original Message----- 
        From: Murali_Pavuloori/ 
        Sent: Friday, August 29, 2003 3:35 PM 
        To: Multiple recipients of list ORACLE-L 
        Subject: RE: get sid (session id) and serial#? 


        Which version of db are you on? This is not available on 



  The information contained in this email is confidential and   intended only for the use of the individual or entity named   above. If the reader of this message is not the intended   recipient, you are hereby notified that any dissemination,   distribution, or copying of this communication is strictly   prohibited. Thomson Scientific will accept no responsibility   or liability in respect to this email other than to the addressee.   If you have received this communication in error, please   notify us immediately via email:

Please see the official ORACLE-L FAQ:
Author: Arup Nanda

Fat City Network Services    -- 858-538-5051
San Diego, California        -- Mailing list and web hosting services
To REMOVE yourself from this mailing list, send an E-Mail message
to: (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Mon Sep 01 2003 - 11:24:25 CDT

Original text of this message