ALL_QUEUES
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
, then this view describes all queues in the database.
Related Views
DBA_QUEUES
describes all queues in the database.
USER_QUEUES
describes the operational characteristics of every queue owned by the current user. This view does not display the OWNER
column.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Owner of the queue |
|
|
|
Name of the queue |
|
|
|
Name of the table the queue data resides in |
|
|
|
Object number of the queue |
|
|
Type of the queue:
|
|
|
|
Maximum number of retries allowed when dequeuing from the queue |
|
|
|
Time interval between retries |
|
|
|
Indicates whether the queue is enabled for enqueue ( |
|
|
|
Indicates whether the queue is enabled for dequeue ( |
|
|
|
Time interval (in seconds) processed messages are retained in the queue, or |
|
|
|
User specified comment |
|
|
|
Network name |
|
|
|
|
See Also:
Oracle Database Advanced Queuing User's Guide for more information Advanced Queuing