V$BUFFERED_PUBLISHERS definition in Oracle Database 11.2
V$BUFFERED_PUBLISHERS

select
  queue_id,                                -- QUEUE_ID NUMBER
  queue_schema,                            -- QUEUE_SCHEMA VARCHAR2(30)
  queue_name,                              -- QUEUE_NAME VARCHAR2(30)
  sender_name,                             -- SENDER_NAME VARCHAR2(30)
  sender_address,                          -- SENDER_ADDRESS VARCHAR2(1024)
  sender_protocol,                         -- SENDER_PROTOCOL NUMBER
  num_msgs,                                -- NUM_MSGS NUMBER
  cnum_msgs,                               -- CNUM_MSGS NUMBER
  last_enqueued_msg,                       -- LAST_ENQUEUED_MSG NUMBER
  unbrowsed_msgs,                          -- UNBROWSED_MSGS NUMBER
  overspilled_msgs,                        -- OVERSPILLED_MSGS NUMBER
  memory_usage,                            -- MEMORY_USAGE NUMBER
  elapsed_enqueue_time,                    -- ELAPSED_ENQUEUE_TIME NUMBER
  enqueue_cpu_time,                        -- ENQUEUE_CPU_TIME NUMBER
  last_enqueue_time,                       -- LAST_ENQUEUE_TIME TIMESTAMP(3) WITH TIME ZONE
  publisher_state                          -- PUBLISHER_STATE VARCHAR2(59)
from
  gv$buffered_publishers
where
  inst_id = USERENV('Instance')

home |  up