Oracle9i Supplied PL/SQL Packages and Types Reference
Release 1 (9.0.1)

Part Number A89852-02
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_ORACLE_TRACE_USER, 2 of 2


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 36-1 SET_ORACLE_TRACE Procedure Parameters
Parameter  Description 
on_off
 

TRUE or FALSE: Turns tracing on or off. 

collection_name
 

Oracle TRACE collection name to be used. 

facility_name
 

Oracle TRACE facility name to be used. 

Example

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

Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2001, 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