V$AQ

V$AQ displays statistics for the queues in the database.

Column	Datatype	Description
`QID`	`NUMBER`	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