Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
|
|
View PDF |
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 |