Administrative Interface: Views, 15 of 16

Select the Number of Messages in Different States for the Whole Database

To refer to the table of all basic operations having to do with the Operational Interface see:

"Use Case Model: Administrative Interface -- Views"

GV$AQ

Provides information about the number of messages in different states for the whole database.

Column Name & Description	Null?	Type
`QID` -- the identity of the queue. This is the same as the `qid` in `user_queues` and `dba_queues.`		`NUMBER`
`WAITING` -- the number of messages in the state '`WAITING`'.		`NUMBER`
`READY` -- the number of messages in state '`READY`'.		`NUMBER`
`EXPIRED` -- the number of messages in state '`EXPIRED`'.		`NUMBER`
`TOTAL_WAIT` -- the number of seconds for which messages in the queue have been waiting in state '`READY`'		`NUMBER`
`AVERAGE_WAIT` -- the average number of seconds a message in state '`READY`' has been waiting to be dequeued.		`NUMBER`