DBA Data[Home] [Help]

VIEW: SYS.ALL_XSTREAM_OUTBOUND_PROGRESS

Source

View Text - Preformatted

select xp."SERVER_NAME",xp."SOURCE_DATABASE",xp."PROCESSED_LOW_POSITION",xp."PROCESSED_LOW_TIME",xp."OLDEST_POSITION",xp."SOURCE_ROOT_NAME",xp."PROCESSED_LOW_SCN",xp."OLDEST_SCN"
from dba_xstream_outbound_progress xp, all_apply a
 where a.apply_name = xp.server_name
View Text - HTML Formatted

SELECT XP."SERVER_NAME"
, XP."SOURCE_DATABASE"
, XP."PROCESSED_LOW_POSITION"
, XP."PROCESSED_LOW_TIME"
, XP."OLDEST_POSITION"
, XP."SOURCE_ROOT_NAME"
, XP."PROCESSED_LOW_SCN"
, XP."OLDEST_SCN" FROM DBA_XSTREAM_OUTBOUND_PROGRESS XP
, ALL_APPLY A
WHERE A.APPLY_NAME = XP.SERVER_NAME