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.
When the actions parameter in the DBMS_STREAMS_ADM.SET_MESSAGE_TRACKING procedure is set to DBMS_STREAMS_ADM.ACTION_MEMORY, information about the LCRs is tracked in memory, and this view is populated with information about the LCRs. Currently, DBMS_STREAMS_ADM.ACTION_MEMORY is the only valid setting for the actions parameter in the procedure.
| 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(9) WITH TIME ZONE |
Time when the action was performed |
MESSAGE_CREATION_TIME |
DATE |
Time when the message was created |
MESSAGE_NUMBER |
NUMBER |
SCN of the message |
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(128) |
Transaction ID |
COMMAND_TYPE |
VARCHAR2(30) |
Command type of the LCR |
MESSAGE_POSITION |
RAW(64) |
Reserved for internal use |
PURPOSEFoot 1 |
VARCHAR2(10) |
Purpose of the LCR stream:
|
Footnote 1 This column is available starting with Oracle Database 11g Release 2 (11.2.0.2).