DBA Data[Home] [Help]

VIEW: SYS.ALL_XSTREAM_INBOUND_PROGRESS

Source

View Text - Preformatted

select xp."SERVER_NAME",xp."PROCESSED_LOW_POSITION",xp."APPLIED_LOW_POSITION",xp."APPLIED_HIGH_POSITION",xp."SPILL_POSITION",xp."OLDEST_POSITION",xp."OLDEST_MESSAGE_NUMBER",xp."APPLIED_MESSAGE_NUMBER",xp."APPLIED_TIME",xp."APPLIED_MESSAGE_CREATE_TIME",xp."SPILL_MESSAGE_NUMBER",xp."SOURCE_DATABASE",xp."SOURCE_ROOT_NAME"
  from dba_xstream_inbound_progress xp, all_apply ap
    where ap.apply_name = xp.server_name
View Text - HTML Formatted

SELECT XP."SERVER_NAME"
, XP."PROCESSED_LOW_POSITION"
, XP."APPLIED_LOW_POSITION"
, XP."APPLIED_HIGH_POSITION"
, XP."SPILL_POSITION"
, XP."OLDEST_POSITION"
, XP."OLDEST_MESSAGE_NUMBER"
, XP."APPLIED_MESSAGE_NUMBER"
, XP."APPLIED_TIME"
, XP."APPLIED_MESSAGE_CREATE_TIME"
, XP."SPILL_MESSAGE_NUMBER"
, XP."SOURCE_DATABASE"
, XP."SOURCE_ROOT_NAME"
FROM DBA_XSTREAM_INBOUND_PROGRESS XP
, ALL_APPLY AP
WHERE AP.APPLY_NAME = XP.SERVER_NAME