select
  queue_id,                                -- QUEUE_ID NUMBER
  queue_schema,                            -- QUEUE_SCHEMA VARCHAR2(30)
  queue_name,                              -- QUEUE_NAME VARCHAR2(30)
  publisher_name,                          -- PUBLISHER_NAME VARCHAR2(30)
  publisher_address,                       -- PUBLISHER_ADDRESS VARCHAR2(1024)
  protocol,                                -- PROTOCOL NUMBER
  enqueued_msgs,                           -- ENQUEUED_MSGS NUMBER
  elapsed_enqueue_time,                    -- ELAPSED_ENQUEUE_TIME NUMBER
  enqueue_cpu_time,                        -- ENQUEUE_CPU_TIME NUMBER
  last_enqueue_time,                       -- LAST_ENQUEUE_TIME TIMESTAMP(6)
  enqueue_transactions                     -- ENQUEUE_TRANSACTIONS NUMBER
from
  gv$persistent_publishers
where
  inst_id = USERENV('Instance')