1. Database Reference
  2. Dynamic Performance Views
  3. Dynamic Performance (V$) Views: V$SCHEDULER_RUNNING_JOBS to V$ZONEMAP_USAGE_STATS
  4. V$STREAMS_MESSAGE_TRACKING

9.86 V$STREAMS_MESSAGE_TRACKING

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.

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.

  • 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

TRACKING_LABEL

VARCHAR2(128)

User-specified tracking label

TAG

RAW(128)

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(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)

Reserved for internal use

PURPOSE

CHAR(7)

Purpose of the LCR stream:

  • Streams - The LCR stream flows through an Oracle Streams configuration

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_STREAMS_ADM.SET_MESSAGE_TRACKING procedure