RE: set_sql_trace_in_session

From: Hallas John <John.Hallas_at_btcellnet.net>
Date: Tue, 20 Nov 2001 00:23:20 -0800
Message-ID: <F001.003C9189.20011119235517@fatcity.com>

Note
134940.1 on Metalink indicates that it is still available. It is created by the dbmsutil.sql script.
<SPAN
class=776394807-20112001> 
Found
the following, never heard of it before but it seems to do the same thing as dbms_system.set_sql_trace_in_session

<FONT color=#330099
face="Arial, Helvetica, sans-serif">DBMS_ORACLE_TRACE_AGENT, 2 of 2

Summary of
Subprograms
This package contains only one subprogram: SET_ORACLE_TRACE_IN_SESSION.
<FONT color=#330099
face="Arial, Helvetica, sans-serif">SET_ORACLE_TRACE_IN_SESSION Procedure
This procedure collects Oracle Trace data for a database session other than your own. It enables Oracle TRACE in the session identified by (sid, serial#). These value are taken from v$session.
<FONT color=#330099
face="Arial, Helvetica, sans-serif">SyntaxDBMS_ORACLE_TRACE_AGENT.SET_ORACLE_TRACE_IN_SESSION (

   sid                NUMBER   DEFAULT 0,
   serial#            NUMBER   DEFAULT 0,
   on_off IN          BOOLEAN  DEFAULT false,

   collection_name IN VARCHAR2 DEFAULT '',    facility_name IN VARCHAR2 DEFAULT '');

<FONT color=#330099
face="Arial, Helvetica, sans-serif">Parameters<A name=1001726>
<A
name=1001729>Table
27-1 SET_ORACLE_TRACE_IN_SESSION Procedure Parameters
<TABLE border=1 cellPadding=3 cellSpacing=0 class=Formal frame=hsides rules=groups width="100%">      

    <FONT
      face="Arial, Helvetica, sans-serif">Parameter      <FONT
      face="Arial, Helvetica, sans-serif">Description       

    sid
      

      Session ID.    

    serial#
      

      Session serial number.    

    on_off
      

      TRUE or FALSE. Turns tracing on or 
      off. 
  

    collection_name
      

      The Oracle TRACE collection name to be used.    

    facility_name
      

      The Oracle TRACE facility name to be   used. <FONT
face="Times New Roman" size=2>-----Original Message-----From: Paul Baumgartel [mailto:treegarden_at_yahoo.com]Sent: 19 November 2001 16:25To: Multiple recipients of list ORACLE-LSubject: RE: set_sql_trace_in_session
Thanks. I'm looking at the online version of that manual,   same part number, and DBMS_SYSTEM doesn't even appear on the list of packages:   

  <A
  href="file:///U:/Oracle/817/DOC/appdev.817/a76936/dbms_sta.htm#999107">52   DBMS_STATS        
<A

      href="file:///U:/Oracle/817/DOC/appdev.817/a76936/dbms_sta.htm#1007950">Using 
      DBMS_STATS 


      <A 

      href="file:///U:/Oracle/817/DOC/appdev.817/a76936/dbms_sta.htm#1000552">Types 
      
  

    <A
    href="file:///U:/Oracle/817/DOC/appdev.817/a76936/dbms_st2.htm#1000574"><STRONG     class=Bold>Summary of Subprograms     

<A

      href="file:///U:/Oracle/817/DOC/appdev.817/a76936/dbms_st2.htm#1000577">Setting 
      or Getting Statistics 


      <A 

      href="file:///U:/Oracle/817/DOC/appdev.817/a76936/dbms_st2.htm#1003946">PREPARE_COLUMN_VALUES 
      Procedure 


      <A 

      href="file:///U:/Oracle/817/DOC/appdev.817/a76936/dbms_st2.htm#1003948">SET_COLUMN_STATS 
      Procedure 


      <A 

      href="file:///U:/Oracle/817/DOC/appdev.817/a76936/dbms_st2.htm#1003950">SET_INDEX_STATS 
      Procedure 


      <A 

      href="file:///U:/Oracle/817/DOC/appdev.817/a76936/dbms_st2.htm#1003952">SET_TABLE_STATS 
      Procedure 


      <A 

      href="file:///U:/Oracle/817/DOC/appdev.817/a76936/dbms_st2.htm#1003954">CONVERT_RAW_VALUE 
      Procedure 


      <A 

      href="file:///U:/Oracle/817/DOC/appdev.817/a76936/dbms_st2.htm#1003956">GET_COLUMN_STATS 
      Procedure 


      <A 

      href="file:///U:/Oracle/817/DOC/appdev.817/a76936/dbms_st2.htm#1003958">GET_INDEX_STATS 
      Procedure 


      <A 

      href="file:///U:/Oracle/817/DOC/appdev.817/a76936/dbms_st2.htm#1003960">GET_TABLE_STATS 
      Procedure 


      <A 

      href="file:///U:/Oracle/817/DOC/appdev.817/a76936/dbms_st2.htm#1003962">DELETE_COLUMN_STATS 
      Procedure 


      <A 

      href="file:///U:/Oracle/817/DOC/appdev.817/a76936/dbms_st2.htm#1000961">DELETE_INDEX_STATS 
      Procedure 


      <A 

      href="file:///U:/Oracle/817/DOC/appdev.817/a76936/dbms_st2.htm#1003966">DELETE_TABLE_STATS 
      Procedure 


      <A 

      href="file:///U:/Oracle/817/DOC/appdev.817/a76936/dbms_st2.htm#1008251">DELETE_SCHEMA_STATS 
      Procedure 


      <A 

      href="file:///U:/Oracle/817/DOC/appdev.817/a76936/dbms_st2.htm#1008396">DELETE_DATABASE_STATS 
      Procedure 


      <A 

      href="file:///U:/Oracle/817/DOC/appdev.817/a76936/dbms_st2.htm#1010202">Transferring 
      Statistics 


      <A 

      href="file:///U:/Oracle/817/DOC/appdev.817/a76936/dbms_st2.htm#1002705">CREATE_STAT_TABLE 
      Procedure 


      <A 

      href="file:///U:/Oracle/817/DOC/appdev.817/a76936/dbms_st2.htm#1003975">DROP_STAT_TABLE 
      Procedure 


      <A 

      href="file:///U:/Oracle/817/DOC/appdev.817/a76936/dbms_st2.htm#1001111">EXPORT_COLUMN_STATS 
      Procedure 


      <A 

      href="file:///U:/Oracle/817/DOC/appdev.817/a76936/dbms_st2.htm#1003978">EXPORT_INDEX_STATS 
      Procedure 


      <A 

      href="file:///U:/Oracle/817/DOC/appdev.817/a76936/dbms_st2.htm#1003980">EXPORT_TABLE_STATS 
      Procedure 


      <A 

      href="file:///U:/Oracle/817/DOC/appdev.817/a76936/dbms_st2.htm#1003982">EXPORT_SCHEMA_STATS 
      Procedure 


      <A 

      href="file:///U:/Oracle/817/DOC/appdev.817/a76936/dbms_st2.htm#1008494">EXPORT_DATABASE_STATS 
      Procedure 


      <A 

      href="file:///U:/Oracle/817/DOC/appdev.817/a76936/dbms_st2.htm#1003984">IMPORT_COLUMN_STATS 
      Procedure 


      <A 

      href="file:///U:/Oracle/817/DOC/appdev.817/a76936/dbms_st2.htm#1003986">IMPORT_INDEX_STATS 
      Procedure 


      <A 

      href="file:///U:/Oracle/817/DOC/appdev.817/a76936/dbms_st2.htm#1003988">IMPORT_TABLE_STATS 
      Procedure 


      <A 

      href="file:///U:/Oracle/817/DOC/appdev.817/a76936/dbms_st2.htm#1003990">IMPORT_SCHEMA_STATS 
      Procedure 


      <A 

      href="file:///U:/Oracle/817/DOC/appdev.817/a76936/dbms_st2.htm#1008637">IMPORT_DATABASE_STATS 
      Procedure 


      <A 

      href="file:///U:/Oracle/817/DOC/appdev.817/a76936/dbms_st2.htm#1010205">Gathering 
      Optimizer Statistics 


      <A 

      href="file:///U:/Oracle/817/DOC/appdev.817/a76936/dbms_st2.htm#1001337">GATHER_INDEX_STATS 
      Procedure 


      <A 

      href="file:///U:/Oracle/817/DOC/appdev.817/a76936/dbms_st2.htm#1003993">GATHER_TABLE_STATS 
      Procedure 


      <A 

      href="file:///U:/Oracle/817/DOC/appdev.817/a76936/dbms_st2.htm#1003995">GATHER_SCHEMA_STATS 
      Procedure 


      <A 

      href="file:///U:/Oracle/817/DOC/appdev.817/a76936/dbms_st2.htm#1003997">GATHER_DATABASE_STATS 
      Procedure 


      <A 

      href="file:///U:/Oracle/817/DOC/appdev.817/a76936/dbms_st2.htm#1003999">GENERATE_STATS 
      Procedure 


      <A 

      href="file:///U:/Oracle/817/DOC/appdev.817/a76936/dbms_st2.htm#1010210">Example 
      

  <A
  href="file:///U:/Oracle/817/DOC/appdev.817/a76936/dbms_tra.htm#998100">53   DBMS_TRACE
  Do you find it in the printed manual?

• Hallas John <John.Hallas_at_btcellnet.net> wrote: > It is in the 8.1.6 documentation I have just looked at > (Oracle8i Supplied PL/SQL Packages Reference > Release 2 (8.1.6) A76936-01 > > However I have a page on my website which shows how to put various > bits of > tracing on > try http://www.hcresources.co.uk for the home page or > http://www.hcresources.f2s.com/trace.htm > to go direct. > > John > > -----Original Message----- > Sent: 19 November 2001 15:05 > To: Multiple recipients of list ORACLE-L > > > DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION isn't documented in the 8.1.6/7 > doc sets. The package (and the procedure) exists, though even the > package spec source code is wrapped. What gives? Is this package > about to be desupported? Is there an alternative way of setting > trace > on in another se! ! ssion? > > __________________________________________________ > Do You Yahoo!? > Find the one for you at Yahoo! Personals > http://personals.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Paul Baumgartel > INET: treegarden_at_yahoo.com > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing > Lists >
  • > To REMOVE yourself from this mailing list, send an E-Mail message > to: ListGuru_at_fatcity.com (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). > > >! !

    ---

    > This email and any attachments may be confidential and the subject of > legal professional privilege. Any disclosure, use, storage or > copying > of this email without the consent of the sender is strictly > prohibited. > Please notify the sender immediately if you are not the intended > recipient and then delete the email from your inbox and do not > disclose the contents to another person, use, copy or store the > information in any medium. >

    ---

    > >

  Do You Yahoo!?Find the one for you at <A   href="http://rd.yahoo.com/mktg/mail/txt/tagline/?http://personals.yahoo.com"   target=_blank>Yahoo! Personals. Received on Tue Nov 20 2001 - 02:23:20 CST