Oracle8i Supplied Packages Reference Release 8.1.5 A68001-01 |
|
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.
This package contains only one subprogram: SET_ORACLE_TRACE
.
This procedure collects Oracle Trace data for your own database session.
DBMS_ORACLE_TRACE_USER.SET_ORACLE_TRACE ( on_off IN BOOLEAN DEFAULT false, collection_name IN VARCHAR2 DEFAULT '', facility_name IN VARCHAR2 DEFAULT '');
Parameter | Description |
---|---|
on_off |
|
collection_name |
Oracle |
facility_name |
Oracle |
EXECUTE DBMS_ORACLE_TRACE_USER.SET_ORACLE_TRACE (TRUE,'MYCOLL','oracle');