GV$BUFFERED_PUBLISHERS definition in Oracle Database 10.2 / www.oracledba.ru
GV$BUFFERED_PUBLISHERS
select
inst_id, -- INST_ID NUMBER
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
decode -- PUBLISHER_STATE VARCHAR2(59)
(bitand (publisher_flags, 7), 1, 'IN FLOW CONTROL: TOO MANY UNBROWSED MESSAGES', 2, 'IN FLOW CONTROL: OVERSPILLED MESSAGES', 4, 'IN FLOW CONTROL: INSUFFICIENT MEMORY AND UNBROWSED MESSAGES', 0, 'PUBLISHING MESSAGES')
from
x$buffered_publishers