25
DBMS_ORACLE_TRACE_USER

DBMS_ORACLE_TRACE_USER provides public access to the Oracle TRACE instrumentation for the calling user. Using the Oracle Trace stored procedures, you can invoke an Oracle Trace collection for your own session or for another session.

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 25-1 SET_ORACLE_TRACE Procedure Parameters

on_off

collection_name

facility_name

Example

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