GV$PERSISTENT_PUBLISHERS definition in Oracle Database 11.2
GV$PERSISTENT_PUBLISHERS

select
  p.inst_id,                               -- INST_ID NUMBER
  p.queue_id,                              -- QUEUE_ID NUMBER
  q.queue_schema,                          -- QUEUE_SCHEMA VARCHAR2(30)
  q.queue_name,                            -- QUEUE_NAME VARCHAR2(30)
  p.publisher_name,                        -- PUBLISHER_NAME VARCHAR2(30)
  p.publisher_address,                     -- PUBLISHER_ADDRESS VARCHAR2(1024)
  p.protocol,                              -- PROTOCOL NUMBER
  p.enqueued_msgs,                         -- ENQUEUED_MSGS NUMBER
  p.elapsed_enqueue_time/10000,            -- ELAPSED_ENQUEUE_TIME NUMBER
  p.enqueue_cpu_time/10000,                -- ENQUEUE_CPU_TIME NUMBER
  p.last_enqueue_time,                     -- LAST_ENQUEUE_TIME TIMESTAMP(6)
  p.enqueue_transactions                   -- ENQUEUE_TRANSACTIONS NUMBER
from
  x$persistent_publishers p,
  x$persistent_queues q
where
  p.inst_id = q.inst_id and p.queue_id = q.queue_id

home |  up