Skip Headers
Oracle® Database Reference
12c Release 1 (12.1)

E17615-23
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

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:

Column Datatype Description
TRACKING_LABEL VARCHAR2(30) User-specified tracking label
TAG RAW(30) First 30 bytes of the tag of the LCR
COMPONENT_NAME VARCHAR2(30) Name of the component that processed the LCR
COMPONENT_TYPE VARCHAR2(30) 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(30) Owner of the object
OBJECT_NAME VARCHAR2(30) Name of the object
XID VARCHAR2(128) Transaction ID
COMMAND_TYPE VARCHAR2(30) 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: