VIEW: SYS._DBA_STREAMS_MSG_NOTIFICATIONS

Source

View Text - Preformatted

select c.streams_name, c.queue_name, c.queue_owner, c.rset_name, c.rset_owner,
       c.neg_rset_name, c.neg_rset_owner,
       decode(UPPER(substr(r.location_name,1,instr(r.location_name,'://') -1)),
              'PLSQL', 'PROCEDURE',
              'MAILTO', 'MAIL',
              'HTTP', 'HTTP'),
       substr(r.location_name, instr(r.location_name, '://') + 3),
       r.user_context, r.context_size, r.any_context, r.context_type
  from sys."_DBA_STREAMS_MESSAGE_CONSUMERS" c, sys.reg$ r
 where '"' ||c.queue_owner||'"."'||c.queue_name||'":"'||c.streams_name || '"'
       = r.subscription_name (+)
   and NVL(r.namespace, 1) = 1

View Text - HTML Formatted

SELECT C.STREAMS_NAME
, C.QUEUE_NAME
, C.QUEUE_OWNER
, C.RSET_NAME
, C.RSET_OWNER
, C.NEG_RSET_NAME
, C.NEG_RSET_OWNER
, DECODE(UPPER(SUBSTR(R.LOCATION_NAME
, 1
, INSTR(R.LOCATION_NAME
, '://') -1))
, 'PLSQL'
, 'PROCEDURE'
, 'MAILTO'
, 'MAIL'
, 'HTTP'
, 'HTTP')
, SUBSTR(R.LOCATION_NAME
, INSTR(R.LOCATION_NAME
, '://') + 3)
, R.USER_CONTEXT
, R.CONTEXT_SIZE
, R.ANY_CONTEXT
, R.CONTEXT_TYPE
FROM SYS."_DBA_STREAMS_MESSAGE_CONSUMERS" C
, SYS.REG$ R
WHERE '"' ||C.QUEUE_OWNER||'"."'||C.QUEUE_NAME||'":"'||C.STREAMS_NAME || '"' = R.SUBSCRIPTION_NAME (+)
AND NVL(R.NAMESPACE
, 1) = 1