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

home |  up  |  mailbox