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 |
|
|
|
|