7.257 V$GOLDENGATE_MESSAGE_TRACKING

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 to 1 or another relatively low value via the Oracle GoldenGate DBOPTIONS 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 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.

Column Datatype Description

TRACKING_LABEL

VARCHAR2(128)

User-specified tracking label

TAG

RAW(128)

First 128 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(312)

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

See Also:

Oracle Database PL/SQL Packages and Types Reference for more information about the DBMS_XSTREAM_ADM.SET_MESSAGE_TRACKING procedure