Skip Headers
Oracle® Database Reference
12c Release 1 (12.1)

E17615-23
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
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_AGE 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_SIZE NUMBER Size of queue, which is the total number of bytes allocated for all messages and metadata
CON_ID NUMBER The ID of the container to which the data pertains. Possible values include:
  • 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.

  • 1: This value is used for rows containing data that pertain to only the root

  • n: Where n is the applicable container ID for the rows containing data