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 |
---|---|---|
|
|
User-specified tracking label |
|
|
First 30 bytes of the tag of the LCR |
|
|
Name of the component that processed the LCR |
|
|
Type of the component that processed the LCR |
|
|
Action performed on the LCR |
|
|
Details of the action |
|
|
Time when the action was performed |
|
|
Time when the message was created |
|
|
SCN of the message |
|
|
Globally unique OID of the LCR |
|
|
Name of the source database |
|
|
Owner of the object |
|
|
Name of the object |
|
|
Transaction ID |
|
|
Command type of the LCR |
|
|
Reserved for internal use |
|
|
Purpose of the LCR stream:
|
|
|
The ID of the container to which the data pertains. Possible values include:
|
See Also:
Oracle Database PL/SQL Packages and Types Reference for more information about the DBMS_STREAMS_ADM.SET_MESSAGE_TRACKING
procedure