select
  queue_id,                                -- QUEUE_ID NUMBER
  queue_schema,                            -- QUEUE_SCHEMA VARCHAR2(30)
  queue_name,                              -- QUEUE_NAME VARCHAR2(30)
  startup_time,                            -- STARTUP_TIME DATE
  num_msgs,                                -- NUM_MSGS NUMBER
  spill_msgs,                              -- SPILL_MSGS NUMBER
  cnum_msgs,                               -- CNUM_MSGS NUMBER
  cspill_msgs,                             -- CSPILL_MSGS NUMBER
  expired_msgs,                            -- EXPIRED_MSGS NUMBER
  oldest_msgid,                            -- OLDEST_MSGID RAW(16)
  oldest_msg_enqtm,                        -- OLDEST_MSG_ENQTM TIMESTAMP(3)
  queue_state,                             -- QUEUE_STATE VARCHAR2(25)
  elapsed_enqueue_time,                    -- ELAPSED_ENQUEUE_TIME NUMBER
  elapsed_dequeue_time,                    -- ELAPSED_DEQUEUE_TIME NUMBER
  elapsed_transformation_time,             -- ELAPSED_TRANSFORMATION_TIME NUMBER
  elapsed_rule_evaluation_time,            -- ELAPSED_RULE_EVALUATION_TIME NUMBER
  enqueue_cpu_time,                        -- ENQUEUE_CPU_TIME NUMBER
  dequeue_cpu_time,                        -- DEQUEUE_CPU_TIME NUMBER
  last_enqueue_time,                       -- LAST_ENQUEUE_TIME TIMESTAMP(3) WITH TIME ZONE
  last_dequeue_time                        -- LAST_DEQUEUE_TIME TIMESTAMP(3) WITH TIME ZONE
from
  gv$buffered_queues
where
  inst_id = USERENV('Instance')