Oracle 视图 V$GOLDENGATE_MESSAGE_TRACKING 官方解释,作用,如何使用详细说明
本站中文解释
Oracle视图V$GOLDENGATE_MESSAGE_TRACKING用于跟踪GoldenGate复制时,所处理的消息。这些消息可以是在源数据库中完成的DML操作,也可以是在目标数据库中完成的DML操作。它用于跟踪复制过程中已经完成的操作,以及正等待复制的操作。
OracleV$GOLDENGATE_MESSAGE_TRACKING视图也有助于检查复制是否有效,以及在哪些步骤出现问题。它还能够提供有关正在等待复制的信息,以及在消息复制期间出现的错误的详细信息。
使用V$GOLDENGATE_MESSAGE_TRACKING视图的方法是:
1.查询复制过程中,仍未处理的消息条目:
SELECT *
FROM V$GOLDENGATE_MESSAGE_TRACKING
WHERE STATUS=’PENDING’;
2.查询复制过程中出现错误的消息条目:
SELECT *
FROM V$GOLDENGATE_MESSAGE_TRACKING
WHERE STATUS=’ERROR’;
3.检查消息条目是否已处理:
SELECT *
FROM V$GOLDENGATE_MESSAGE_TRACKING
WHERE STATUS=’COMPLETED’;
4.检查复制消息的详细内容:
SELECT *
FROM V$GOLDENGATE_MESSAGE_TRACKING
WHERE MESSAGE_COLUMN='[MESSAGE_DETAIL]’;
官方英文解释
V$GOLDENGATE_MESSAGE_TRACKING
displays information about LCRs tracked through the stream that are processed by Oracle GoldenGate components.
You can track an LCR through a stream using one of the following methods:
-
Set the
message_tracking_frequency
apply process parameter to1
or another relatively low value via the Oracle GoldenGateDBOPTIONS INTEGRATEDPARAMS
parameter. -
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.
Column | Datatype | Description |
---|---|---|
|
|
User-specified tracking label |
|
|
First 128 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.SET_MESSAGE_TRACKING
procedure