Advanced Queuing Data Dictionary Views
USER_QUEUES: Information about queues in a user's schema
DBA_QUEUES: Information about all queues in the database
USER_QUEUE_SCHEDULES: Information about propagation of messages in queue
USER_QUEUE_PRIVILEGES: Information about queuing privileges for the current user
V$AQ: Dynamic information about queues, such as number of messages of various types in queue
The available preference classes, their attributes, and the valid values are described in data dictionary views; these are:
The first three in the above list each contain a description field explaining their contents. The CTX_DDL package also contains procedures for deleting objects. These are DROP_PREFERENCE, DROP_SECTION_GROUP, deleting from the interMedia Text data dictionary, and UNSET_ATTRIBUTE, which removes an attribute from a preference object. Since some attributes have default values, and some are by default blank, it would be clearer in your code to explicitly re-set attributes on objects that will continue in use.
Oracle QUEUE Types
- DBA_QUEUE_TABLES: All Queue Tables in Database
The DBA_QUEUE_TABLES view contains information about the owner instance for a queue table. A queue table can contain multiple queues. In this case, each queue in a queue table has the same owner instance as the queue table. Its columns are the same as those in ALL_QUEUE_TABLES.
- USER_QUEUE_TABLES: Queue Tables in User Schema
The USER_QUEUE_TABLES view is the same as DBA_QUEUE_TABLES with the exception that it only shows queue tables in the user's schema. It does not contain a column for OWNER.
- ALL_QUEUE_TABLES: Queue Tables Queue Accessible to the Current User
The ALL_QUEUE_TABLES view describes queue tables accessible to the current user.
- DBA_QUEUES: All Queues in Database The DBA_QUEUES view specifies operational characteristics for every queue in a database. Its columns are the same as those ALL_QUEUES.
- USER_QUEUES: Queues In User Schema The USER_QUEUES view is the same as DBA_QUEUES with the exception that it only shows queues in the user's schema.
- ALL_QUEUES: Queues for Which User Has Any Privilege The ALL_QUEUES view describes all queues on which the current user has enqueue or dequeue privileges. If the user has any Advanced Queuing system privileges, like
MANAGE ANY QUEUE, ENQUEUE ANY QUEUE or DEQUEUE ANY QUEUE, this view describes all queues in the database.
- DBA_QUEUE_SCHEDULES: All Propagation Schedules The DBA_QUEUE_SCHEDULES view describes all the current schedules in the database for propagating messages.
- USER_QUEUE_SCHEDULES: Propagation Schedules in User Schema The USER_QUEUE_SCHEDULES view is the same as DBA_QUEUE_SCHEDULES with the exception that it only shows queue schedules in the user's schema.
- QUEUE_PRIVILEGES: Queues for Which User Has Queue Privilege The QUEUE_PRIVILEGES view describes queues for which the user is the grantor, grantee, or owner. It also shows queues for which an enabled role on the queue is granted to PUBLIC.
- AQ$Queue_Table_Name: Messages in Queue Table
The AQ$Queue_Table_Name view describes the queue table in which message data is stored. This view is automatically created with each queue table and should be used for querying the queue data. The dequeue history data (time, user identification and transaction identification) is only valid for single-consumer queues.