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
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
|
|
|