V$STREAMS_MESSAGE_TRACKING definition in Oracle Database 11.2
V$STREAMS_MESSAGE_TRACKING

select
  TRACKING_LABEL,                          -- TRACKING_LABEL VARCHAR2(30)
  TAG,                                     -- TAG RAW(30)
  COMPONENT_NAME,                          -- COMPONENT_NAME VARCHAR2(30)
  COMPONENT_TYPE,                          -- COMPONENT_TYPE VARCHAR2(30)
  ACTION,                                  -- ACTION VARCHAR2(50)
  ACTION_DETAILS,                          -- ACTION_DETAILS VARCHAR2(100)
  TIMESTAMP,                               -- TIMESTAMP TIMESTAMP(9) WITH TIME ZONE
  MESSAGE_CREATION_TIME,                   -- MESSAGE_CREATION_TIME DATE
  MESSAGE_NUMBER,                          -- MESSAGE_NUMBER NUMBER
  TRACKING_ID,                             -- TRACKING_ID RAW(16)
  SOURCE_DATABASE_NAME,                    -- SOURCE_DATABASE_NAME VARCHAR2(128)
  OBJECT_OWNER,                            -- OBJECT_OWNER VARCHAR2(30)
  OBJECT_NAME,                             -- OBJECT_NAME VARCHAR2(30)
  XID,                                     -- XID VARCHAR2(128)
  COMMAND_TYPE,                            -- COMMAND_TYPE VARCHAR2(30)
  MESSAGE_POSITION                         -- MESSAGE_POSITION RAW(64)
from
  GV$STREAMS_MESSAGE_TRACKING
where
  INST_ID = USERENV('Instance')

home |  up