VIEW: SYS.DBA_APPLY_PROGRESS

Source

View Text - Preformatted

select ap.apply_name, am.source_db_name,
       am.commit_scn,
       am.oldest_scn,
       apply_time,
       am.applied_message_create_time,
       oldest_transaction_id,
       spill_lwm_scn,
       am.source_root_name
  from streams$_apply_process ap, "_DBA_APPLY_MILESTONE" am,
        sys.xstream$_server xs
 where ap.apply# = am.apply#
   and ap.apply_name = xs.server_name (+)

View Text - HTML Formatted

SELECT AP.APPLY_NAME
, AM.SOURCE_DB_NAME
, AM.COMMIT_SCN
, AM.OLDEST_SCN
, APPLY_TIME
, AM.APPLIED_MESSAGE_CREATE_TIME
, OLDEST_TRANSACTION_ID
, SPILL_LWM_SCN
, AM.SOURCE_ROOT_NAME
FROM STREAMS$_APPLY_PROCESS AP
, "_DBA_APPLY_MILESTONE" AM
, SYS.XSTREAM$_SERVER XS
WHERE AP.APPLY# = AM.APPLY#
AND AP.APPLY_NAME = XS.SERVER_NAME (+)