DBMS_ORACLE_TRACE_USER, 2 of 2

Summary of Subprograms

This package contains only one subprogram: SET_ORACLE_TRACE.

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