Skip Headers
Oracle® Database Reference
11g Release 1 (11.1)

B28320-03
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_QUEUES

V$BUFFERED_QUEUES displays information about all buffered queues in the instance. There is one row per queue.

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
STARTUP_TIME DATE Startup time
NUM_MSGS NUMBER Total number of messages currently in the buffered queue
SPILL_MSGS NUMBER Current number of overflow messages spilled to disk from the buffered queue
CNUM_MSGS NUMBER Cumulative total number of messages enqueued into the buffered queue since the database last started
CSPILL_MSGS NUMBER Cumulative total number of overflow messages spilled to disk from the buffered queue since the database last started
EXPIRED_MSGS NUMBER Number of expired messages
QUEUE_STATE VARCHAR2(25) Indicates whether the queue is in recovery mode (QUEUE IS IN RECOVERY MODE) or not (NORMAL)