GV$BUFFERED_SUBSCRIBERS

select
s.inst_id,               -- INST_ID NUMBER
s.queue_id,              -- QUEUE_ID NUMBER
q.queue_schema,          -- QUEUE_SCHEMA VARCHAR2(30)
q.queue_name,            -- QUEUE_NAME VARCHAR2(30)
s.subscriber_id,         -- SUBSCRIBER_ID NUMBER
s.subscriber_name,       -- SUBSCRIBER_NAME VARCHAR2(30)
s.subscriber_address,    -- SUBSCRIBER_ADDRESS VARCHAR2(1024)
s.protocol,              -- PROTOCOL NUMBER
s.subscriber_type,       -- SUBSCRIBER_TYPE VARCHAR2(30)
q.startup_time,          -- STARTUP_TIME DATE
s.last_browsed_seq,      -- LAST_BROWSED_SEQ NUMBER
s.last_browsed_num,      -- LAST_BROWSED_NUM NUMBER
s.last_dequeued_seq,     -- LAST_DEQUEUED_SEQ NUMBER
s.last_dequeued_num,     -- LAST_DEQUEUED_NUM NUMBER
s.current_enq_seq,       -- CURRENT_ENQ_SEQ NUMBER
s.num_msgs,              -- NUM_MSGS NUMBER
s.cnum_msgs,             -- CNUM_MSGS NUMBER
s.total_dequeued_msg,    -- TOTAL_DEQUEUED_MSG NUMBER
s.total_spilled_msg,     -- TOTAL_SPILLED_MSG NUMBER
s.expired_msgs           -- EXPIRED_MSGS NUMBER
from
x$buffered_subscribers s,
x$buffered_queues q 
where
s.inst_id = q.inst_id and s.queue_id = q.queue_id and bitand (q.flags, 16) = 0
home |  up  |  mailbox