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')