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_MSGID`^Foot 1	`RAW(16)`	Message ID of the oldest message in the queue
`OLDEST_MSG_ENQTM`^Footref 1	`TIMESTAMP(6)`	Enqueue time of the oldest message in the queue

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