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

Figure 10-14 Selecting the Number of Messages in Different States for the Whole Database

Text description of the illustration adq10qvw2.gif

Name of View

GV$AQ

Purpose

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

Table 10-14 AQ$<queue_table_name>_R

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