2.114 ALL_DEQUEUE_QUEUES
ALL_DEQUEUE_QUEUES describes all queues on which the current user has dequeue privileges. If the user has any Advanced Queuing system privileges, such as DEQUEUE ANY QUEUE or MANAGE ANY QUEUE, then this view describes all queues in the database.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Owner of the queue |
|
|
|
|
Name of the queue |
|
|
|
|
Name of the table in which the queue data resides |
|
|
|
|
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 that processed messages are retained in the queue, or |
|
|
|
|
User-specified comment |
|
|
|
|
Network name of the queue service |
|
|
|
|
|