Skip Headers
Oracle® Database Reference
11g Release 1 (11.1)

Part Number B28320-01
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
View PDF


V$STREAMS_MESSAGE_TRACKING displays information about LCRs tracked through the stream that are processed by each Streams client. Use the DBMS_STREAMS_ADM.SET_MESSAGE_TRACKING procedure to specify a tracking label that becomes part of each LCR generated by the current session.

If the actions parameter in the DBMS_STREAMS_ADM.SET_MESSAGE_TRACKING procedure is set to DBMS_STREAMS_ADM.ACTION_MEMORY, then information about the LCRs is tracked in memory and this view is populated with information about the LCRs. If the actions parameter is set to DBMS_STREAMS_ADM.ACTION_TRACE, then this view is not populated and information about the LCRs is sent to the trace files at each database.

Column Datatype Description
TRACKING_LABEL VARCHAR2(30) User-specified tracking label
TAG RAW(30) First 30 bytes of the tag of the LCR
COMPONENT_NAME VARCHAR2(30) Name of the component that processed the LCR
COMPONENT_TYPE VARCHAR2(30) Type of the component that processed the LCR
ACTION VARCHAR2(50) Action performed on the LCR
ACTION_DETAILS VARCHAR2(100) Details of the action
TIMESTAMP TIMESTAMP(13) WITH TIME ZONE Time when the action was performed
MESSAGE_CREATION_TIME DATE Time when the message was created
TRACKING_ID RAW(16) Globally unique OID of the LCR
SOURCE_DATABASE_NAME VARCHAR2(128) Name of the source database
OBJECT_OWNER VARCHAR2(30) Owner of the object
OBJECT_NAME VARCHAR2(30) Name of the object
XID VARCHAR2(22) Transaction ID
COMMAND_TYPE VARCHAR2(30) Command type of the LCR