9.142 V$XSTREAM_MESSAGE_TRACKING
V$XSTREAM_MESSAGE_TRACKING
displays information about LCRs tracked through the stream that are processed by XStream components.
You can track an LCR through a stream using one of the following methods:
-
Set the
message_tracking_frequency
capture process parameter to1
or another relatively low value for XStream Outbound processes. -
Set the
message_tracking_frequency
apply process parameter to1
or another relatively low value for XStream Inbound processes. -
Use the
DBMS_XSTREAM_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_XSTREAM_ADM.SET_MESSAGE_TRACKING
procedure is set toDBMS_XSTREAM_ADM.ACTION_MEMORY
, information about the LCRs is tracked in memory, and this view is populated with information about the LCRs. Currently,DBMS_XSTREAM_ADM.ACTION_MEMORY
is the only valid setting for theactions
parameter in the procedure.Note:
This view does not display information about messages flowing in an Oracle GoldenGate configuration. To view information about such message streams, query the
V$GOLDENGATE_MESSAGE_TRACKING
view.
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 |
|
|
Position of the message |
|
|
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_XSTREAM_ADM package
-
Oracle Database XStream Guide for more information about XStream concepts