Dynamic Performance (V$) Views, 4 of 179

V$AQ

This view describes statistics for the queues in the database.

Column	Datatype	Description
`QID`	`NUMBER`	The unique queue identifier
`WAITING`	`NUMBER`	Number of messages in the queue in the state '`WAITING`'
`READY`	`NUMBER`	Number of messages in the queue in the state '`READY`'
`EXPIRED`	`NUMBER`	Number of messages in the queue the state '`EXPIRED`'
`TOTAL_WAIT`	`NUMBER`	Total wait time of all '`READY`' messages in the queue
`AVERAGE_WAIT`	`NUMBER`	Average wait time of '`READY`' messages in the queue