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_ORACLE_TRACE_AGENT, 2 of 2


Summary of DBMS_ORACLE_TRACE_AGENT Subprograms

This package contains only one subprogram: SET_ORACLE_TRACE_IN_SESSION.

SET_ORACLE_TRACE_IN_SESSION Procedure

This procedure collects Oracle Trace data for a database session other than your own. It enables Oracle TRACE in the session identified by (sid, serial#). These value are taken from v$session.

Syntax

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

Parameters

Table 39-1 SET_ORACLE_TRACE_IN_SESSION Procedure Parameters
Parameter Description

sid

Session ID.

serial#

Session serial number.

on_off

TRUE or FALSE. Turns tracing on or off.

collection_name

The Oracle TRACE collection name to be used.

facility_name

The Oracle TRACE facility name to be used.

Usage Notes

If the collection does not occur, then check the following:

Example

EXECUTE DBMS_ORACLE_TRACE_AGENT.SET_ORACLE_TRACE_IN_SESSION 
(8,12,TRUE,'NEWCOLL','oracled'); 

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