This illustration shows the use case Select Number of Messages in States for Whole Database in the AQ Administrative Interface.

The name of the User view is GV$AQ.

To Select the Number of Messages in States for a Whole Database, you must either list all queue statistics, or list the attribute names. If you choose to list the attribute names, you must list at least one attribute.

For a list of the attributes, see the table AQ$<queue_table_name>_R.