VIEW: SYS._DBA_STREAMS_PROCESSES

Source

View Text - Preformatted

select decode(bitand(c.flags, 512), 512, 5, 1) streams_type,
       c.capture_name streams_name,
       c.ruleset_owner, c.ruleset_name, 'POSITIVE'
  from streams$_capture_process c
union all
select 1 streams_type, c.capture_name streams_name,
       c.negative_ruleset_owner, c.negative_ruleset_name, 'NEGATIVE'
  from streams$_capture_process c
  where  bitand(c.flags, 512) != 512
union all
select 2 streams_type, p.propagation_name streams_name,
       p.ruleset_schema, p.ruleset, 'POSITIVE'
  from streams$_propagation_process p
union all
select 2 streams_type, p.propagation_name streams_name,
       p.negative_ruleset_schema, p.negative_ruleset, 'NEGATIVE'
  from streams$_propagation_process p
union all
select 3 streams_type, a.apply_name streams_name,
       a.ruleset_owner, a.ruleset_name, 'POSITIVE'
  from streams$_apply_process a
union all
select 3 streams_type, a.apply_name streams_name,
       a.negative_ruleset_owner, a.negative_ruleset_name, 'NEGATIVE'
  from streams$_apply_process a
union all
select 4 streams_type, d.streams_name,
       d.rset_owner, d.rset_name, 'POSITIVE'
  from streams$_message_consumers d
union all
select 4 streams_type, d.streams_name,
       d.neg_rset_owner, d.neg_rset_name, 'NEGATIVE'
  from streams$_message_consumers d

View Text - HTML Formatted

SELECT DECODE(BITAND(C.FLAGS
, 512)
, 512
, 5
, 1) STREAMS_TYPE
, C.CAPTURE_NAME STREAMS_NAME
, C.RULESET_OWNER
, C.RULESET_NAME
, 'POSITIVE'
FROM STREAMS$_CAPTURE_PROCESS C UNION ALL SELECT 1 STREAMS_TYPE
, C.CAPTURE_NAME STREAMS_NAME
, C.NEGATIVE_RULESET_OWNER
, C.NEGATIVE_RULESET_NAME
, 'NEGATIVE'
FROM STREAMS$_CAPTURE_PROCESS C
WHERE BITAND(C.FLAGS
, 512) != 512 UNION ALL SELECT 2 STREAMS_TYPE
, P.PROPAGATION_NAME STREAMS_NAME
, P.RULESET_SCHEMA
, P.RULESET
, 'POSITIVE'
FROM STREAMS$_PROPAGATION_PROCESS P UNION ALL SELECT 2 STREAMS_TYPE
, P.PROPAGATION_NAME STREAMS_NAME
, P.NEGATIVE_RULESET_SCHEMA
, P.NEGATIVE_RULESET
, 'NEGATIVE'
FROM STREAMS$_PROPAGATION_PROCESS P UNION ALL SELECT 3 STREAMS_TYPE
, A.APPLY_NAME STREAMS_NAME
, A.RULESET_OWNER
, A.RULESET_NAME
, 'POSITIVE'
FROM STREAMS$_APPLY_PROCESS A UNION ALL SELECT 3 STREAMS_TYPE
, A.APPLY_NAME STREAMS_NAME
, A.NEGATIVE_RULESET_OWNER
, A.NEGATIVE_RULESET_NAME
, 'NEGATIVE'
FROM STREAMS$_APPLY_PROCESS A UNION ALL SELECT 4 STREAMS_TYPE
, D.STREAMS_NAME
, D.RSET_OWNER
, D.RSET_NAME
, 'POSITIVE'
FROM STREAMS$_MESSAGE_CONSUMERS D UNION ALL SELECT 4 STREAMS_TYPE
, D.STREAMS_NAME
, D.NEG_RSET_OWNER
, D.NEG_RSET_NAME
, 'NEGATIVE'
FROM STREAMS$_MESSAGE_CONSUMERS D