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:
|