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
  s.message_lag,                           -- MESSAGE_LAG NUMBER
  s.elapsed_dequeue_time/10000,            -- ELAPSED_DEQUEUE_TIME NUMBER
  s.dequeue_cpu_time/10000,                -- DEQUEUE_CPU_TIME NUMBER
  s.last_dequeue_time,                     -- LAST_DEQUEUE_TIME TIMESTAMP(3) WITH TIME ZONE
  s.oldest_msgid,                          -- OLDEST_MSGID RAW(16)
  s.oldest_msg_enqtm                       -- OLDEST_MSG_ENQTM TIMESTAMP(3)
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