VIEW: SYS.DBA_XSTREAM_OUTBOUND_PROGRESS

Source

View Text - Preformatted

select xs.server_name, xs.source_database,
          am.xout_processed_position, am.xout_processed_time,
          oldest_position, xs.source_root_name,
          am.processed_scn, am.oldest_scn
from  streams$_apply_process ap, "_DBA_APPLY_MILESTONE" am,
      dba_xstream_outbound xs
 where ap.apply# = am.apply#
   and ap.apply_name = xs.server_name

View Text - HTML Formatted

SELECT XS.SERVER_NAME
, XS.SOURCE_DATABASE
, AM.XOUT_PROCESSED_POSITION
, AM.XOUT_PROCESSED_TIME
, OLDEST_POSITION
, XS.SOURCE_ROOT_NAME
, AM.PROCESSED_SCN
, AM.OLDEST_SCN FROM STREAMS$_APPLY_PROCESS AP
, "_DBA_APPLY_MILESTONE" AM
, DBA_XSTREAM_OUTBOUND XS
WHERE AP.APPLY# = AM.APPLY#
AND AP.APPLY_NAME = XS.SERVER_NAME