Oracle® Database Reference 10g Release 1 (10.1) Part Number B10755-01 |
|
|
View PDF |
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 |