Oracle教程 2023-04-02

Oracle 视图 V$XSTREAM_MESSAGE_TRACKING 官方解释，作用，如何使用详细说明

？

Oracle视图V$XSTREAM_MESSAGE_TRACKING是Oracle Streams中用于监控消息跟踪信息的视图，它用于跟踪消息的传递情况，对对象上的传递操作进行记录。通过这个视图，用户能够得到实时的消息跟踪记录，包括消息是否被抓取、路由和传递的信息。

使用方法:
1、查看特定消息的跟踪信息:
SELECT * FROM v$XSTREAM_MESSAGE_TRACKING WHERE message_id = ‘specific_message_id’;

2、查询指定日期范围内的消息跟踪信息:
SELECT * FROM v$XSTREAM_MESSAGE_TRACKING WHERE capture_time > ‘start_date’ AND capture_time

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 to 1 or another relatively low value for XStream Outbound processes.
Set the message_tracking_frequency apply process parameter to 1 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 to DBMS_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 the actions 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
`TRACKING_LABEL`	`VARCHAR2(128)`	User-specified tracking label
`TAG`	`RAW(30)`	First 30 bytes of the tag of the LCR
`COMPONENT_NAME`	`VARCHAR2(128)`	Name of the component that processed the LCR
`COMPONENT_TYPE`	`VARCHAR2(128)`	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(128)`	Owner of the object
`OBJECT_NAME`	`VARCHAR2(128)`	Name of the object
`XID`	`VARCHAR2(128)`	Transaction ID
`COMMAND_TYPE`	`VARCHAR2(128)`	Command type of the LCR
`MESSAGE_POSITION`	`RAW(64)`	Position of the message
`CON_ID`	`NUMBER`	The ID of the container to which the data pertains. Possible values include: `0`: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs. `1`: This value is used for rows containing data that pertain to only the root n: Where n is the applicable container ID for the rows containing data