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`'
`AVERAGE_MSG_AGE`	`NUMBER`	Average age of the messages in the queue'
`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
`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