../E40402-16.epub /> ../E40402-16.mobi />

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
OLDEST_MSGID RAW(16) Message ID of the oldest message
OLDEST_MSG_ENQTM TIMESTAMP(3) Enqueue time of the oldest message
QUEUE_STATE VARCHAR2(25) Indicates whether the queue is in recovery mode (QUEUE IS IN RECOVERY MODE) or not (NORMAL)
ELAPSED_ENQUEUE_TIME NUMBER Total time spent in enqueue (in hundredths of a second)
ELAPSED_DEQUEUE_TIME NUMBER Total time spent in dequeue (in hundredths of a second)
ELAPSED_TRANSFORMATION_TIME NUMBER Total time for evaluating transformations (in hundredths of a second)
ELAPSED_RULE_EVALUATION_TIME NUMBER Total time for rule evaluations (in hundredths of a second)
ENQUEUE_CPU_TIME NUMBER Total CPU time for enqueue (in hundredths of a second)
DEQUEUE_CPU_TIME NUMBER Total CPU time for dequeue (in hundredths of a second)
AVG_MSG_AGEFoot 1  NUMBER Average age of messages in the queue
LAST_ENQUEUE_TIME TIMESTAMP(3) WITH TIME ZONE Last message enqueue time
LAST_DEQUEUE_TIME TIMESTAMP(3) WITH TIME ZONE Last message dequeue time
QUEUE_SIZEFootref 1 NUMBER Size of queue, which is the total number of bytes allocated for all messages and metadata

Footnote 1 This column is available starting with Oracle Database 11g Release 2 (11.2.0.2).