VIEW: SYS._V$SXGG_MESSAGE_TRACKING

Source

View Text - Preformatted

select "TRACKING_LABEL","TAG","COMPONENT_NAME","COMPONENT_TYPE","ACTION","ACTION_DETAILS","TIMESTAMP","MESSAGE_CREATION_TIME","MESSAGE_NUMBER","TRACKING_ID","SOURCE_DATABASE_NAME","OBJECT_OWNER","OBJECT_NAME","XID","COMMAND_TYPE","MESSAGE_POSITION","PURPOSE","CON_ID" from v$streams_message_tracking
union all
select tracking_label, tag, component_name, component_type, action,
action_details, timestamp, message_creation_time, message_number,
tracking_id, source_database_name, object_owner, object_name, xid,
command_type, message_position, NULL, con_id
from v$xstream_message_tracking
union all
select tracking_label, tag, component_name, component_type, action,
action_details, timestamp, message_creation_time, message_number,
tracking_id, source_database_name, object_owner, object_name, xid,
command_type, utl_raw.cast_to_raw(message_position), NULL, con_id
from v$goldengate_message_tracking

View Text - HTML Formatted

SELECT "TRACKING_LABEL"
, "TAG"
, "COMPONENT_NAME"
, "COMPONENT_TYPE"
, "ACTION"
, "ACTION_DETAILS"
, "TIMESTAMP"
, "MESSAGE_CREATION_TIME"
, "MESSAGE_NUMBER"
, "TRACKING_ID"
, "SOURCE_DATABASE_NAME"
, "OBJECT_OWNER"
, "OBJECT_NAME"
, "XID"
, "COMMAND_TYPE"
, "MESSAGE_POSITION"
, "PURPOSE"
, "CON_ID"
FROM V$STREAMS_MESSAGE_TRACKING UNION ALL SELECT TRACKING_LABEL
, TAG
, COMPONENT_NAME
, COMPONENT_TYPE
, ACTION
, ACTION_DETAILS
, TIMESTAMP
, MESSAGE_CREATION_TIME
, MESSAGE_NUMBER
, TRACKING_ID
, SOURCE_DATABASE_NAME
, OBJECT_OWNER
, OBJECT_NAME
, XID
, COMMAND_TYPE
, MESSAGE_POSITION
, NULL
, CON_ID FROM V$XSTREAM_MESSAGE_TRACKING UNION ALL SELECT TRACKING_LABEL
, TAG
, COMPONENT_NAME
, COMPONENT_TYPE
, ACTION
, ACTION_DETAILS
, TIMESTAMP
, MESSAGE_CREATION_TIME
, MESSAGE_NUMBER
, TRACKING_ID
, SOURCE_DATABASE_NAME
, OBJECT_OWNER
, OBJECT_NAME
, XID
, COMMAND_TYPE
, UTL_RAW.CAST_TO_RAW(MESSAGE_POSITION)
, NULL
, CON_ID FROM V$GOLDENGATE_MESSAGE_TRACKING