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
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.