Oracle Data Dictionary Views

Because queues reside in the Oracle database, a number of data dictionary views shape the operation of queues and give you information on the queues. For some of these views, there are three versions:

1. an ALL_ view, where all available entities are shown;
2. a USER_ view, which shows only entities in the current user's schema; and
3. a DBA_ view, which shows entities available to a user with DBA_ privileges.

To access the ALL_ or DBA_ versions, a user must have the appropriate privileges.

The QUEUES data dictionary views, ALL_QUEUES, USER_QUEUES, and DBA_QUEUES, display information about a queue, including:

1. NAME: The name of the queue
2. QUEUE_TABLE: The queue table that holds the queue
3. ENQUEUE_ENABLED: Whether a queue can allow messages to be enqueued
4. DEQUEUE_ENABLED: Whether a queue can allow messages to be dequeued
5. RETENTION: The amount of time a message is retained in the queue

The following two views have DBA_ and USER_ versions:

1. QUEUE_SCHEDULES: The messages in a queue can be propagated to other queues according to a schedule. This view provides information about propagation schedules.
2. QUEUE_PRIVILEGES: Shows the queuing privileges granted to the current session.

In addition to the static data dictionary views described above, there is a dynamic view for queues that gives you access to current statistics and performance information about queues. The V$ AQ view gives statistics for current activity in the view, such as the number of messages that are waiting or have expired and the total and average wait time that messages are in the queue. There are two flavors of this view. One flavor has the V prefix, as in V$ AQ, which gives all the information for a single instance of Oracle; the other flavor has a GV prefix, as in GV$ AQ, which gives information for all instances in a parallel server environment.

Click the link below to match data dictionary views about Advanced Queuing with their information.
Advanced Queuing Data Dictionary Views