SET_ORACLE_TRACE Procedure

This procedure collects Oracle Trace data for your own database session.

Syntax

DBMS_ORACLE_TRACE_USER.SET_ORACLE_TRACE ( 
   on_off          IN BOOLEAN  DEFAULT false,
   collection_name IN VARCHAR2 DEFAULT '',
   facility_name   IN VARCHAR2 DEFAULT '');

Parameters

Table 36-1 SET_ORACLE_TRACE Procedure Parameters

Parameter	Description
on_off	TRUE or FALSE: Turns tracing on or off.
collection_name	Oracle TRACE collection name to be used.
facility_name	Oracle TRACE facility name to be used.

Example

EXECUTE DBMS_ORACLE_TRACE_USER.SET_ORACLE_TRACE 
(TRUE,'MYCOLL','oracle');