This illustration shows the use case Selecting Number of Messages in States for Instances in the AQ Administrative Interface.

The name of the User view is V$AQ.

To Select the Number of Messages in States for Instances, 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