Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

E40402-14
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
PDF · Mobi · ePub

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 an Oracle 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 Number of messages that have been enqueued but not browsed
OVERSPILLED_MSGS NUMBER Number of messages that have been spilled but not browsed
MEMORY_USAGE NUMBER Percentage of the Streams pool that is being used (or 0 if there is no Streams pool)
ELAPSED_ENQUEUE_TIME NUMBER Total time spent in enqueue (in hundredths of a second)
ENQUEUE_CPU_TIME NUMBER Total CPU time for enqueue (in hundredths of a second)
LAST_ENQUEUE_TIME TIMESTAMP(3) WITH TIME ZONE Last message enqueue time
PUBLISHER_STATE VARCHAR2(59) State of the publisher:
  • IN FLOW CONTROL: TOO MANY UNBROWSED MESSAGES

  • IN FLOW CONTROL: OVERSPILLED MESSAGES

  • IN FLOW CONTROL: INSUFFICIENT MEMORY AND UNBROWSED MESSAGES

  • PUBLISHING MESSAGES - Normal