DBA Data[Home] [Help]

VIEW: SYS.ALL_GG_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."APPLIED_LOW_SCN",xp."APPLIED_TIME",xp."APPLIED_MESSAGE_CREATE_TIME",xp."SOURCE_DATABASE",xp."SOURCE_ROOT_NAME",xp."LOGBSN"
  from dba_gg_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."APPLIED_LOW_SCN"
, XP."APPLIED_TIME"
, XP."APPLIED_MESSAGE_CREATE_TIME"
, XP."SOURCE_DATABASE"
, XP."SOURCE_ROOT_NAME"
, XP."LOGBSN"
FROM DBA_GG_INBOUND_PROGRESS XP
, ALL_APPLY AP
WHERE AP.APPLY_NAME = XP.SERVER_NAME