VIEW: SYS._DBA_GGXSTREAM_OUTBOUND

Source

View Text - Preformatted

select server_name, xs.connect_user,
   cap.capture_name, source_database, cap.capture_user, app.queue_owner,
   app.queue_name, user_comment, create_date,
   case when (bitand(xs.flags, 4) = 4)
     then                                                /* uncommitted mode */
       decode(cap.status, 'ENABLED',
              decode (bitand(xs.flags, 8),
                      0, 'DETACHED', 'ATTACHED'), cap.status)
     else                                                /*   committed mode */
       decode(app.status, 'ENABLED',
               decode (bitand(xs.flags, 8),
                      0, 'DETACHED', 'ATTACHED'), app.status) end,
   decode(bitand(xs.flags, 4), 4, 'NO', 0, 'YES'),
   cap.start_scn, cap.start_time, cap.source_root_name, app.purpose
   from sys.xstream$_server xs, dba_apply app, dba_capture cap
   where app.apply_name = xs.server_name and
         cap.queue_owner(+) = app.queue_owner and
         cap.queue_name(+) = app.queue_name and
         bitand(xs.flags, 1) = 1                      /* XStream Out process */

View Text - HTML Formatted

SELECT SERVER_NAME
, XS.CONNECT_USER
, CAP.CAPTURE_NAME
, SOURCE_DATABASE
, CAP.CAPTURE_USER
, APP.QUEUE_OWNER
, APP.QUEUE_NAME
, USER_COMMENT
, CREATE_DATE
, CASE WHEN (BITAND(XS.FLAGS
, 4) = 4) THEN /* UNCOMMITTED MODE */ DECODE(CAP.STATUS
, 'ENABLED'
, DECODE (BITAND(XS.FLAGS
, 8)
, 0
, 'DETACHED'
, 'ATTACHED')
, CAP.STATUS) ELSE /* COMMITTED MODE */ DECODE(APP.STATUS
, 'ENABLED'
, DECODE (BITAND(XS.FLAGS
, 8)
, 0
, 'DETACHED'
, 'ATTACHED')
, APP.STATUS) END
, DECODE(BITAND(XS.FLAGS
, 4)
, 4
, 'NO'
, 0
, 'YES')
, CAP.START_SCN
, CAP.START_TIME
, CAP.SOURCE_ROOT_NAME
, APP.PURPOSE
FROM SYS.XSTREAM$_SERVER XS
, DBA_APPLY APP
, DBA_CAPTURE CAP
WHERE APP.APPLY_NAME = XS.SERVER_NAME AND CAP.QUEUE_OWNER(+) = APP.QUEUE_OWNER AND CAP.QUEUE_NAME(+) = APP.QUEUE_NAME AND BITAND(XS.FLAGS
, 1) = 1 /* XSTREAM OUT PROCESS */