GV$PERSISTENT_SUBSCRIBERS definition in Oracle Database 11.2
GV$PERSISTENT_SUBSCRIBERS

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)
  s.first_activity_time,                   -- FIRST_ACTIVITY_TIME TIMESTAMP(6)
  s.enqueued_msgs,                         -- ENQUEUED_MSGS NUMBER
  s.dequeued_msgs,                         -- DEQUEUED_MSGS NUMBER
  s.avg_msg_age,                           -- AVG_MSG_AGE NUMBER
  s.browsed_msgs,                          -- BROWSED_MSGS NUMBER
  s.expired_msgs,                          -- EXPIRED_MSGS NUMBER
  s.dequeued_msg_latency,                  -- DEQUEUED_MSG_LATENCY NUMBER
  s.last_enqueue_time,                     -- LAST_ENQUEUE_TIME TIMESTAMP(6)
  s.last_dequeue_time,                     -- LAST_DEQUEUE_TIME TIMESTAMP(6)
  s.elapsed_dequeue_time/10000,            -- ELAPSED_DEQUEUE_TIME NUMBER
  s.dequeue_cpu_time/10000,                -- DEQUEUE_CPU_TIME NUMBER
  s.dequeue_transactions,                  -- DEQUEUE_TRANSACTIONS NUMBER
  s.execution_count                        -- EXECUTION_COUNT NUMBER
from
  x$persistent_subscribers s,
  x$persistent_queues q
where
  s.inst_id = q.inst_id and s.queue_id = q.queue_id

home |  up