Skip Headers
Oracle® Database Reference
10g Release 2 (10.2)

Part Number B14237-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

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