V$BUFFERED_PUBLISHERS

V$BUFFERED_PUBLISHERS displays information about all buffered publishers in the instance. There is one row per queue per sender. The values are reset to zero when the database (or instance in a Real Application Clusters (RAC ) environment) restarts.

Column	Datatype	Description
`QUEUE_ID`	`NUMBER`	Identifier for the queue
`QUEUE_SCHEMA`	`VARCHAR2(30)`	Owner of the queue
`QUEUE_NAME`	`VARCHAR2(30)`	Name of the queue
`SENDER_NAME`	`VARCHAR2(30)`	Name of the agent enqueuing the message (the Streams name assigned for a capture process)
`SENDER_ADDRESS`	`VARCHAR2(1024)`	Queue name and database name of the source (last propagating) queue; database name is not specified if the source queue is in the local database
`SENDER_PROTOCOL`	`NUMBER`	Protocol used by the sender's address
`NUM_MSGS`	`NUMBER`	Current number of messages that have yet to be dequeued from the buffer queue
`CNUM_MSGS`	`NUMBER`	Cumulative total number of messages enqueued into the buffered queue since the database last started (comparable to V$STREAMS_CAPTURE total_enqueued_messages
`LAST_ENQUEUED_MSG`	`NUMBER`	Most recently enqueued message identifier
`UNBROWSED_MSGS`	`NUMBER`	The count of messages that have been enqueued, but now browsed
`OVERSPILLED_MSGS`	`NUMBER`	The count of messages that have been spilled, but not browsed
`MEMORY_USAGE`	`NUMBER`	The percentage of the streams pool that is being used (or 0 if there is no streams pool)
`PUBLISHER_STATE`	`VARCHAR2(59)`	State of the publisher. Possible values are: PUBLISHING MESSAGES (normal) IN FLOW CONTROL: TOO MANY UNBROWSED MESSAGES IN FLOW CONTROL: OVERSPILLED MESSAGES IN FLOW CONTROL: INSUFFICIENT MEMORY AND UNBROWSED MESSAGES