|Oracle8i Supplied Packages Reference
DBMS_ORACLE_TRACE_AGENT package provides some system level utilities.
This package is only accessible to user
SYS by default. You can control access to these routines by only granting execute to privileged users.
This package contains only one subprogram:
This procedure collects Oracle Trace data for a database session other than your own. It enables Oracle TRACE in the session identified by (
serial#). These value are taken from
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 '');
Session serial number.
The Oracle TRACE collection name to be used.
The Oracle TRACE facility name to be used.
If the collection does not occur, then check the following:
ORACLE_TRACE_FACILITY_PATHin the initialization file.
DAT. If they do not, then you must run the
OTRCCREFexecutable to create them.
SQLfile (in your Oracle Trace or RDBMS admin directories) to create the packages.
EXECUTEprivilege on the stored procedure.