Oracle8i Supplied Packages Reference
Release 8.1.5

A68001-01

Library

Product

Contents

Index

Prev Next

25
DBMS_ORACLE_TRACE_USER

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.

Summary of Subprograms

This package contains only one subprogram: SET_ORACLE_TRACE.

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 25-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'); 



Prev

Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index