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