RE: set_sql_trace_in_session

[Hallas John]

Note 134940.1 on Metalink indicates that it is still available. It is created by the dbmsutil.sql script.

 

Found the following, never heard of it before but it seems to do the same thing as dbms_system.set_sql_trace_in_session

DBMS_ORACLE_TRACE_AGENT, 2 of 2

---

Summary of Subprograms

This package contains only one subprogram: SET_ORACLE_TRACE_IN_SESSION.

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.

Syntax

DBMS_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 '');

Parameters

Table 27-1 SET_ORACLE_TRACE_IN_SESSION Procedure Parameters

Parameter	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.

-----Original Message-----
From: Paul Baumgartel [mailto:[EMAIL PROTECTED]]
Sent: 19 November 2001 16:25
To: Multiple recipients of list ORACLE-L
Subject: 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:

52 DBMS_STATS

Using DBMS_STATS

Types

Summary of Subprograms

Setting or Getting Statistics

PREPARE_COLUMN_VALUES Procedure

SET_COLUMN_STATS Procedure

SET_INDEX_STATS Procedure

SET_TABLE_STATS Procedure

CONVERT_RAW_VALUE Procedure

GET_COLUMN_STATS Procedure

GET_INDEX_STATS Procedure

GET_TABLE_STATS Procedure

DELETE_COLUMN_STATS Procedure

DELETE_INDEX_STATS Procedure

DELETE_TABLE_STATS Procedure

DELETE_SCHEMA_STATS Procedure

DELETE_DATABASE_STATS Procedure

Transferring Statistics

CREATE_STAT_TABLE Procedure

DROP_STAT_TABLE Procedure

EXPORT_COLUMN_STATS Procedure

EXPORT_INDEX_STATS Procedure

EXPORT_TABLE_STATS Procedure

EXPORT_SCHEMA_STATS Procedure

EXPORT_DATABASE_STATS Procedure

IMPORT_COLUMN_STATS Procedure

IMPORT_INDEX_STATS Procedure

IMPORT_TABLE_STATS Procedure

IMPORT_SCHEMA_STATS Procedure

IMPORT_DATABASE_STATS Procedure

Gathering Optimizer Statistics

GATHER_INDEX_STATS Procedure

GATHER_TABLE_STATS Procedure

GATHER_SCHEMA_STATS Procedure

GATHER_DATABASE_STATS Procedure

GENERATE_STATS Procedure

Example

53 DBMS_TRACE

Do you find it in the printed manual?

--- Hallas John <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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 Yahoo! Personals.