VIEW: SYS.DBA_GG_INBOUND_PROGRESS

Source

View Text - Preformatted

select xs.server_name,
          case
          when (nvl(am.spill_lwm_position, '00') <
                                             nvl(am.lwm_external_pos, '00'))
            then utl_raw.cast_to_varchar2(am.lwm_external_pos)
          else utl_raw.cast_to_varchar2(am.spill_lwm_position)
          end,
          utl_raw.cast_to_varchar2(am.lwm_external_pos),
          utl_raw.cast_to_varchar2(am.applied_high_position),
          utl_raw.cast_to_varchar2(am.spill_lwm_position),
          utl_raw.cast_to_varchar2(am.oldest_position),
          am.commit_scn,
          am.apply_time, am.applied_message_create_time,
          am.source_db_name, am.source_root_name,
          utl_raw.cast_to_varchar2(am.spare5)
from  sys.xstream$_server xs, streams$_apply_process ap,
      "_DBA_APPLY_MILESTONE" am
 where ap.apply# = am.apply#
   and ap.apply_name = xs.server_name
   and bitand(ap.flags, 16384) = 16384                /* GoldenGate */
   and bitand(xs.flags, 2) = 2                        /* XStream In  process */

View Text - HTML Formatted

SELECT XS.SERVER_NAME
, CASE WHEN (NVL(AM.SPILL_LWM_POSITION
, '00') < NVL(AM.LWM_EXTERNAL_POS
, '00')) THEN UTL_RAW.CAST_TO_VARCHAR2(AM.LWM_EXTERNAL_POS) ELSE UTL_RAW.CAST_TO_VARCHAR2(AM.SPILL_LWM_POSITION) END
, UTL_RAW.CAST_TO_VARCHAR2(AM.LWM_EXTERNAL_POS)
, UTL_RAW.CAST_TO_VARCHAR2(AM.APPLIED_HIGH_POSITION)
, UTL_RAW.CAST_TO_VARCHAR2(AM.SPILL_LWM_POSITION)
, UTL_RAW.CAST_TO_VARCHAR2(AM.OLDEST_POSITION)
, AM.COMMIT_SCN
, AM.APPLY_TIME
, AM.APPLIED_MESSAGE_CREATE_TIME
, AM.SOURCE_DB_NAME
, AM.SOURCE_ROOT_NAME
, UTL_RAW.CAST_TO_VARCHAR2(AM.SPARE5) FROM SYS.XSTREAM$_SERVER XS
, STREAMS$_APPLY_PROCESS AP
, "_DBA_APPLY_MILESTONE" AM
WHERE AP.APPLY# = AM.APPLY#
AND AP.APPLY_NAME = XS.SERVER_NAME
AND BITAND(AP.FLAGS
, 16384) = 16384 /* GOLDENGATE */
AND BITAND(XS.FLAGS
, 2) = 2 /* XSTREAM IN PROCESS */