Oracle 视图 ALL_DEQUEUE_QUEUES 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图ALL_DEQUEUE_QUEUES用于查询当前用户可以使用的获取消息的队列（dequeue queues）信息，包括队列的类型、队列的名称、是否可以获取及释放消息等。通常看到该视图只返回队列类型有AQ$_REG_QUEUE和AQ$_P_QUEUE的记录，分别表示单向注册队列和交互式（映射类型）队列。
使用ALL_DEQUEUE_QUEUES视图的方式很简单，只需要执行select‘*’ from 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. Possible values:
|
|
|
|
|
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 |
|
|
|
|
|
|
|
|
|
Queue category. Possible values:
|
|
|
|
|
SINGLE or MULTIPLE recipients
|
Footnote 1 This column is available starting with Oracle Database 21c.
