VIEW: SYS._DBA_GGXSTREAM_INBOUND

Source

View Text - Preformatted

select server_name, xs.queue_owner, xs.queue_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),
   decode(bitand(xs.flags, 4), 4, 'NO', 0, 'YES'), app.purpose
   from sys.xstream$_server xs, dba_apply app
   where app.apply_name = xs.server_name and
         bitand(xs.flags, 2) = 2                      /* XStream In  process */

View Text - HTML Formatted

SELECT SERVER_NAME
, XS.QUEUE_OWNER
, XS.QUEUE_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)
, DECODE(BITAND(XS.FLAGS
, 4)
, 4
, 'NO'
, 0
, 'YES')
, APP.PURPOSE
FROM SYS.XSTREAM$_SERVER XS
, DBA_APPLY APP
WHERE APP.APPLY_NAME = XS.SERVER_NAME AND BITAND(XS.FLAGS
, 2) = 2 /* XSTREAM IN PROCESS */