V$STREAMS_MESSAGE_TRACKING

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
`PURPOSE`^Foot 1	`VARCHAR2(10)`	Purpose of the LCR stream: `Streams` - The LCR stream flows through an Oracle Streams configuration `XStream` - The LCR stream flows through an XStream configuration

^Footnote 1This column is available starting with Oracle Database 11g Release 2 (11.2.0.2).