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 126.96.36.199 to 188.8.131.52 [Release 11.1 to 11.2]
Information in this document applies to any platform.
In the following document :
OracleÂ® Database PL/SQL Packages and Types Reference 11g Release 1 (11.1) Part Number B28419-03
tracking_label IN VARCHAR2 DEFAULT 'Streams_tracking',
actions IN NUMBER DEFAULT DBMS_STREAMS_ADM.ACTION_MEMORY);
Table 130-36 SET_MESSAGE_TRACKING Procedure Parameters
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.
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.
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