Table: ALL_QUEUES
All queues accessible to the user
| Column Name | Description |
|---|---|
| DEQUEUE_ENABLED | Queue is enabled for dequeue |
| ENQUEUE_ENABLED | Queue is enabled for enqueue |
| MAX_RETRIES | Maximum number of retries allowed when dequeuing from the queue |
| NAME | Name of the queue |
| OWNER | Owner of the queue |
| QID | Object number of the queue |
| QUEUE_TABLE | Name of the table the queue data resides in |
| QUEUE_TYPE | Type of the queue |
| RETENTION | Time interval processed messages retained in the queue |
| RETRY_DELAY | Time interval between retries |
| USER_COMMENT | User specified comment |