VIEW: SYS.DBA_QUEUE_PUBLISHERS

Source

View Text - Preformatted

select t.schema QUEUE_OWNER, q.name QUEUE_NAME,
        p.p_name PUBLISHER_NAME, p.p_address PUBLISHER_ADDRESS,
        p.p_protocol PUBLISHER_PROTOCOL, p.p_rule PUBLISHER_RULE,
        p.p_rule_name PUBLISHER_RULE_NAME, p.p_ruleset PUBLISHER_RULESET,
        p.p_transformation PUBLISHER_TRANSFORMATION
from
 system.aq$_queue_tables t,  system.aq$_queues q,
 sys.aq$_publisher p, sys.user$ u
where
 q.table_objno = t.objno and q.eventid = p.queue_id
 and u.name  = t.schema

View Text - HTML Formatted

SELECT T.SCHEMA QUEUE_OWNER
, Q.NAME QUEUE_NAME
, P.P_NAME PUBLISHER_NAME
, P.P_ADDRESS PUBLISHER_ADDRESS
, P.P_PROTOCOL PUBLISHER_PROTOCOL
, P.P_RULE PUBLISHER_RULE
, P.P_RULE_NAME PUBLISHER_RULE_NAME
, P.P_RULESET PUBLISHER_RULESET
, P.P_TRANSFORMATION PUBLISHER_TRANSFORMATION FROM SYSTEM.AQ$_QUEUE_TABLES T
, SYSTEM.AQ$_QUEUES Q
, SYS.AQ$_PUBLISHER P
, SYS.USER$ U WHERE Q.TABLE_OBJNO = T.OBJNO
AND Q.EVENTID = P.QUEUE_ID
AND U.NAME = T.SCHEMA