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)
  first_activity_time,                     -- FIRST_ACTIVITY_TIME TIMESTAMP(6)
  enqueued_msgs,                           -- ENQUEUED_MSGS NUMBER
  dequeued_msgs,                           -- DEQUEUED_MSGS NUMBER
  avg_msg_age,                             -- AVG_MSG_AGE NUMBER
  browsed_msgs,                            -- BROWSED_MSGS NUMBER
  expired_msgs,                            -- EXPIRED_MSGS NUMBER
  dequeued_msg_latency,                    -- DEQUEUED_MSG_LATENCY NUMBER
  last_enqueue_time,                       -- LAST_ENQUEUE_TIME TIMESTAMP(6)
  last_dequeue_time,                       -- LAST_DEQUEUE_TIME TIMESTAMP(6)
  elapsed_dequeue_time,                    -- ELAPSED_DEQUEUE_TIME NUMBER
  dequeue_cpu_time,                        -- DEQUEUE_CPU_TIME NUMBER
  dequeue_transactions,                    -- DEQUEUE_TRANSACTIONS NUMBER
  execution_count                          -- EXECUTION_COUNT NUMBER
from
  gv$persistent_subscribers
where
  inst_id = USERENV('Instance')