GV$BUFFERED_PUBLISHERS

select
inst_id,                 -- INST_ID NUMBER
queue_id,                -- QUEUE_ID NUMBER
queue_schema,            -- QUEUE_SCHEMA VARCHAR2(30)
queue_name,              -- QUEUE_NAME VARCHAR2(30)
sender_name,             -- SENDER_NAME VARCHAR2(30)
sender_address,          -- SENDER_ADDRESS VARCHAR2(1024)
sender_protocol,         -- SENDER_PROTOCOL NUMBER
num_msgs,                -- NUM_MSGS NUMBER
cnum_msgs,               -- CNUM_MSGS NUMBER
last_enqueued_msg        -- LAST_ENQUEUED_MSG NUMBER
from
x$buffered_publishers 
where
(bitand (publisher_flags, 2) != 2)
home |  up  |  mailbox