My Oracle Support Banner

DBMS_STREAMS_ADM.SET_MESSAGE_TRACKING ACTIONS ....ACTION_TRACE (Doc ID 1060716.1)

Last updated on AUGUST 18, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.6 to 11.2.0.1 [Release 11.1 to 11.2]
Information in this document applies to any platform.

Symptoms

In the following document :

Oracle® Database PL/SQL Packages and Types Reference  11g Release 1 (11.1) Part Number B28419-03

================================

SET_MESSAGE_TRACKING Procedure

Syntax
DBMS_STREAMS_ADM.SET_MESSAGE_TRACKING(
tracking_label IN VARCHAR2 DEFAULT 'Streams_tracking',
actions IN NUMBER DEFAULT DBMS_STREAMS_ADM.ACTION_MEMORY);

Parameters
Table 130-36 SET_MESSAGE_TRACKING Procedure Parameters
Parameter Description

Tracking_label
The label used to track the LCRs produced by the session.
Set this parameter to NULL to stop message tracking in the current session.
The size limit for a label is 4,000 bytes.

Actions
If DBMS_STREAMS_ADM.ACTION_MEMORY is specified, then the LCRs are tracked in
memory, and the V$STREAMS_MESSAGE_TRACKING dynamic performance view is
populated with information about the LCRs.

If DBMS_STREAMS_ADM.ACTION_TRACE is specified, then the LCRs are tracked in
the trace files of each database that processes the LCRs.

The values specified for this parameter are enumerated constants. Enumerated constants must be prefixed with the package name.


But according to the code : Only ACTION_MEMORY is implemented, so when trying
to set the tracking action to: ACTION_TRACE , the function fails with error,
this issue has been reported in bug 9196726 . The bug status is 32 , thus I
have opened that documentation bug. This part of the documentation should be
fixed as many customers are trying to set the tracking and getting the errors
in the bug. Please check the bug 9196726 for more details.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.