V$PERSISTENT_QUEUES

V$PERSISTENT_QUEUES displays information about all active persistent queues in the database since the queues' first activity time. There is one row per queue. The rows are deleted when the database (or instance in an Oracle RAC environment) restarts.

Column Datatype Description
QUEUE_ID NUMBER Identifier for the queue
QUEUE_TABLE_ID NUMBER Queue table identifier
QUEUE_SCHEMA VARCHAR2(30) Owner of the queue
QUEUE_NAME VARCHAR2(30) Name of the queue
FIRST_ACTIVITY_TIME TIMESTAMP(6) First queue activity time since database startup
ENQUEUED_MSGS NUMBER Number of messages enqueued
DEQUEUED_MSGS NUMBER Number of messages dequeued

Note: This column will not be incremented until all the subscribers of the message have dequeued the message and its retention time has elapsed.

BROWSED_MSGS NUMBER Number of messages that have been browsed
ELAPSED_ENQUEUE_TIME NUMBER Total time (in hundredths of a second) spent doing enqueue
ELAPSED_DEQUEUE_TIME NUMBER Total time (in hundredths of a second) spent doing dequeue
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
DEQUEUED_MSG_LATENCY NUMBER Last dequeued message latency (in seconds)
ELAPSED_TRANSFORMATION_TIME NUMBER Total time (in hundredths of a second) spent doing transformation
ELAPSED_RULE_EVALUATION_TIME NUMBER Total time (in hundredths of a second) spent doing rule evaluation
ENQUEUED_EXPIRY_MSGS NUMBER Number of messages enqueued with expiry
ENQUEUED_DELAY_MSGS NUMBER Number of messages enqueued with delay
MSGS_MADE_EXPIRED NUMBER Number of messages expired by time manager
MSGS_MADE_READY NUMBER Number of messages made ready by time manager
LAST_ENQUEUE_TIME TIMESTAMP(6) Last message enqueue time
LAST_DEQUEUE_TIME TIMESTAMP(6) Last message dequeue time
LAST_TM_EXPIRY_TIME TIMESTAMP(6) Last time message was expired by time manager
LAST_TM_READY_TIME TIMESTAMP(6) Last time message was made ready by time manager
ENQUEUE_TRANSACTIONS NUMBER Number of enqueue transactions
DEQUEUE_TRANSACTIONS NUMBER Number of dequeue transactions
EXECUTION_COUNT NUMBER Number of executions of the dequeue cursor
OLDEST_MSGIDFoot 1  RAW(16) Message ID of the oldest message in the queue
OLDEST_MSG_ENQTMFootref 1 TIMESTAMP(6) Enqueue time of the oldest message in the queue

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