select
  queue_id,                                -- QUEUE_ID NUMBER
  queue_table_id,                          -- QUEUE_TABLE_ID NUMBER
  queue_schema,                            -- QUEUE_SCHEMA VARCHAR2(30)
  queue_name,                              -- QUEUE_NAME VARCHAR2(30)
  first_activity_time,                     -- FIRST_ACTIVITY_TIME TIMESTAMP(6)
  enqueued_msgs,                           -- ENQUEUED_MSGS NUMBER
  dequeued_msgs,                           -- DEQUEUED_MSGS NUMBER
  browsed_msgs,                            -- BROWSED_MSGS NUMBER
  elapsed_enqueue_time,                    -- ELAPSED_ENQUEUE_TIME NUMBER
  elapsed_dequeue_time,                    -- ELAPSED_DEQUEUE_TIME NUMBER
  enqueue_cpu_time,                        -- ENQUEUE_CPU_TIME NUMBER
  dequeue_cpu_time,                        -- DEQUEUE_CPU_TIME NUMBER
  avg_msg_age,                             -- AVG_MSG_AGE NUMBER
  dequeued_msg_latency,                    -- DEQUEUED_MSG_LATENCY NUMBER
  elapsed_transformation_time,             -- ELAPSED_TRANSFORMATION_TIME NUMBER
  elapsed_rule_evaluation_time,            -- ELAPSED_RULE_EVALUATION_TIME NUMBER
  enqueued_expiry_msgs,                    -- ENQUEUED_EXPIRY_MSGS NUMBER
  enqueued_delay_msgs,                     -- ENQUEUED_DELAY_MSGS NUMBER
  msgs_made_expired,                       -- MSGS_MADE_EXPIRED NUMBER
  msgs_made_ready,                         -- MSGS_MADE_READY NUMBER
  last_enqueue_time,                       -- LAST_ENQUEUE_TIME TIMESTAMP(6)
  last_dequeue_time,                       -- LAST_DEQUEUE_TIME TIMESTAMP(6)
  last_tm_expiry_time,                     -- LAST_TM_EXPIRY_TIME TIMESTAMP(6)
  last_tm_ready_time,                      -- LAST_TM_READY_TIME TIMESTAMP(6)
  enqueue_transactions,                    -- ENQUEUE_TRANSACTIONS NUMBER
  dequeue_transactions,                    -- DEQUEUE_TRANSACTIONS NUMBER
  execution_count                          -- EXECUTION_COUNT NUMBER
from
  gv$persistent_queues
where
  inst_id = USERENV('Instance')