select
  queue_id,                                -- QUEUE_ID NUMBER
  queue_schema,                            -- QUEUE_SCHEMA VARCHAR2(30)
  queue_name,                              -- QUEUE_NAME VARCHAR2(30)
  subscriber_id,                           -- SUBSCRIBER_ID NUMBER
  subscriber_name,                         -- SUBSCRIBER_NAME VARCHAR2(30)
  subscriber_address,                      -- SUBSCRIBER_ADDRESS VARCHAR2(1024)
  protocol,                                -- PROTOCOL NUMBER
  subscriber_type,                         -- SUBSCRIBER_TYPE VARCHAR2(30)
  startup_time,                            -- STARTUP_TIME DATE
  last_browsed_seq,                        -- LAST_BROWSED_SEQ NUMBER
  last_browsed_num,                        -- LAST_BROWSED_NUM NUMBER
  last_dequeued_seq,                       -- LAST_DEQUEUED_SEQ NUMBER
  last_dequeued_num,                       -- LAST_DEQUEUED_NUM NUMBER
  current_enq_seq,                         -- CURRENT_ENQ_SEQ NUMBER
  num_msgs,                                -- NUM_MSGS NUMBER
  cnum_msgs,                               -- CNUM_MSGS NUMBER
  total_dequeued_msg,                      -- TOTAL_DEQUEUED_MSG NUMBER
  total_spilled_msg,                       -- TOTAL_SPILLED_MSG NUMBER
  expired_msgs,                            -- EXPIRED_MSGS NUMBER
  message_lag,                             -- MESSAGE_LAG NUMBER
  elapsed_dequeue_time,                    -- ELAPSED_DEQUEUE_TIME NUMBER
  dequeue_cpu_time,                        -- DEQUEUE_CPU_TIME NUMBER
  last_dequeue_time,                       -- LAST_DEQUEUE_TIME TIMESTAMP(3) WITH TIME ZONE
  oldest_msgid,                            -- OLDEST_MSGID RAW(16)
  oldest_msg_enqtm                         -- OLDEST_MSG_ENQTM TIMESTAMP(3)
from
  gv$buffered_subscribers
where
  inst_id = USERENV('Instance')