Skip Headers

Oracle® Database Reference
10g Release 1 (10.1)

Part Number B10755-01
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page

Go to previous page
Go to next page
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