Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: set_sql_trace_in_session

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?

  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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US