VIEW: SYS.DBA_GOLDENGATE_INBOUND

Source

View Text - Preformatted

select substr(xs.user_comment, 1, instr(xs.user_comment, ' ') - 1),
   server_name, app.apply_user, user_comment, create_date,
   decode(app.status, 'ENABLED',
              decode ((select count(*) from gv$propagation_receiver
                         where dst_queue_schema = xs.queue_owner and
                               dst_queue_name = xs.queue_name and
                               (nvl(con_id, 0) = 0 or
                                con_id = sys_context('userenv', 'con_id'))),
                      0, 'DETACHED', 'ATTACHED'), app.status)
   from sys.xstream$_server xs, dba_apply app
   where app.apply_name = xs.server_name and
         app.purpose = 'GoldenGate Apply' and         /* GoldenGate */
         bitand(xs.flags, 2) = 2                      /* XStream In  process */

View Text - HTML Formatted

SELECT SUBSTR(XS.USER_COMMENT
, 1
, INSTR(XS.USER_COMMENT
, ' ') - 1)
, SERVER_NAME
, APP.APPLY_USER
, USER_COMMENT
, CREATE_DATE
, DECODE(APP.STATUS
, 'ENABLED'
, DECODE ((SELECT COUNT(*)
FROM GV$PROPAGATION_RECEIVER
WHERE DST_QUEUE_SCHEMA = XS.QUEUE_OWNER AND DST_QUEUE_NAME = XS.QUEUE_NAME AND (NVL(CON_ID
, 0) = 0 OR CON_ID = SYS_CONTEXT('USERENV'
, 'CON_ID')))
, 0
, 'DETACHED'
, 'ATTACHED')
, APP.STATUS)
FROM SYS.XSTREAM$_SERVER XS
, DBA_APPLY APP
WHERE APP.APPLY_NAME = XS.SERVER_NAME AND APP.PURPOSE = 'GOLDENGATE APPLY'
AND /* GOLDENGATE */ BITAND(XS.FLAGS
, 2) = 2 /* XSTREAM IN PROCESS */