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 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 buffered queue was created (comparable to V$STREAMS_CAPTURE total_enqueued_messages
`LAST_ENQUEUED_MSG`	`NUMBER`	Most recently enqueued message identifier