DBMS_TRACE , 2 of 2

Summary of Subprograms

Table 53-1 DBMS_TRACE Package Subprograms

Subprogram	Description
SET_PLSQL_TRACE Procedure	Starts tracing in the current session.
CLEAR_PLSQL_TRACE Procedure	Stops trace data dumping in session.
PLSQL_TRACE_VERSION procedure	Gets the version number of the trace package.

SET_PLSQL_TRACE Procedure

This procedure enables PL/SQL trace data collection.

Syntax

DBMS_TRACE.SET_PLSQL_TRACE ( 
   trace_level INTEGER);

Parameter

Table 53-2 describes the parameter for the DBMS_TRACE.SET_PLSQL_TRACE syntax.

Table 53-2 SET_PLSQL_TRACE Procedure Parameters

Parameter	Description
trace_level	You must supply one or more of the constants as listed. By summing the constants, you can enable tracing of multiple PL/SQL language features simultaneously. The control constants "trace_pause", "trace_resume" and "trace_stop" should not be used in combination with other constants Also see "Collecting Trace Data" for more information.

Parameter

Description

trace_level

You must supply one or more of the constants as listed. By summing the constants, you can enable tracing of multiple PL/SQL language features simultaneously. The control constants "trace_pause", "trace_resume" and "trace_stop" should not be used in combination with other constants

Also see "Collecting Trace Data" for more information.

CLEAR_PLSQL_TRACE Procedure

This procedure disables trace data collection.

Syntax

DBMS_TRACE.CLEAR_PLSQL_TRACE;

Parameters

None.

PLSQL_TRACE_VERSION procedure

This procedure gets the version number of the trace package. It returns the major and minor version number of the DBMS_TRACE package.

Syntax

DBMS_TRACE.PLSQL_TRACE_VERSION ( 
   major OUT BINARY_INTEGER, 
   minor OUT BINARY_INTEGER);

Parameters

Table 53-3 describes the parameters for the DBMS_TRACE.PLSQL_TRACE_VERSION syntax.

Table 53-3 PLSQL_TRACE_VERSION Procedure Parameters

Parameter	Description
major	Major version number of `DBMS_TRACE`.
minor	Minor version number of `DBMS_TRACE`.