DBA Data[Home] [Help]

VIEW: SYS.ALL_APPLY_PROGRESS

Source

View Text - Preformatted

select ap.apply_name, ap.source_database, ap.applied_message_number,
       ap.oldest_message_number, ap.apply_time, ap.applied_message_create_time,
       ap.oldest_transaction_id, ap.spill_message_number, ap.source_root_name
  from dba_apply_progress ap, all_apply a
 where ap.apply_name = a.apply_name
View Text - HTML Formatted

SELECT AP.APPLY_NAME
, AP.SOURCE_DATABASE
, AP.APPLIED_MESSAGE_NUMBER
, AP.OLDEST_MESSAGE_NUMBER
, AP.APPLY_TIME
, AP.APPLIED_MESSAGE_CREATE_TIME
, AP.OLDEST_TRANSACTION_ID
, AP.SPILL_MESSAGE_NUMBER
, AP.SOURCE_ROOT_NAME
FROM DBA_APPLY_PROGRESS AP
, ALL_APPLY A
WHERE AP.APPLY_NAME = A.APPLY_NAME