Oracle教程 2023-02-23

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`	`VARCHAR2(128)`	`NOT NULL`	Owner of the queue
`NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the queue
`QUEUE_TABLE`	`VARCHAR2(128)`	`NOT NULL`	Name of the table in which the queue data resides
`QID`	`NUMBER`	`NOT NULL`	Object number of the queue
`QUEUE_TYPE`	`VARCHAR2(20)`		Type of the queue. Possible values: `EXCEPTION_QUEUE` `NORMAL_QUEUE`
`MAX_RETRIES`	`NUMBER`		Maximum number of retries allowed when dequeuing from the queue
`RETRY_DELAY`	`NUMBER`		Time interval between retries
`ENQUEUE_ENABLED`	`VARCHAR2(7)`		Indicates whether the queue is enabled for enqueue ( `YES` ) or not ( `NO` )
`DEQUEUE_ENABLED`	`VARCHAR2(7)`		Indicates whether the queue is enabled for dequeue ( `YES` ) or not ( `NO` )
`RETENTION`	`VARCHAR2(40)`		Time interval that processed messages are retained in the queue, or `FOREVER`
`USER_COMMENT`	`VARCHAR2(50)`		User-specified comment
`NETWORK_NAME`	`VARCHAR2(512)`		Network name of the queue service
`SHARDED`	`VARCHAR2(5)`		`TRUE` if the queue is sharded, `FALSE` otherwise
`QUEUE_CATEGORY`^Foot 1	`VARCHAR2(25)`		Queue category. Possible values: `Classic Queue` `Sharded Queue` `Transactional Event Queue`
`RECIPIENTS`^Foot 1	`VARCHAR2(8)`		`SINGLE` or `MULTIPLE` recipients