Skip Headers

Oracle9i Supplied PL/SQL Packages and Types Reference
Release 2 (9.2)

Part Number A96612-01
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to beginning of chapter Go to next page

DBMS_TRACE , 2 of 2


Summary of DBMS_TRACE Subprograms

Table 74-1 DBMS_TRACE 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); 

Parameters

Table 74-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.

CLEAR_PLSQL_TRACE Procedure

This procedure disables trace data collection.

Syntax

DBMS_TRACE.CLEAR_PLSQL_TRACE; 

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 74-3 PLSQL_TRACE_VERSION Procedure Parameters
Parameter Description

major

Major version number of DBMS_TRACE.

minor

Minor version number of DBMS_TRACE.


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 2000, 2002 Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback