Oracle教程 2023-02-23

Oracle 视图 ALL_QUEUE_EVENT_STREAMS 官方解释，作用，如何使用详细说明

ALL_QUEUE_EVENT_STREAMS 视图提供了包含记录在每个事件队列中的事件信息的信息。

权限：SELECT 权限在数据库实例级别上赋予，不需要对对象授予任何权限。

使用：

1.查询正在处理队列中事件流的任何队列：

SELECT * FROM all_queue_event_streams;

2.查询队列中某个事件流名称是STREAM1的队列：

SELECT * FROM all_queue_event_streams WHERE stream_name = ‘STREAM1’;

ALL_QUEUE_EVENT_STREAMS describes the Transactional Event Queue (TEQ) event streams accessible to the current user.

Related Views

DBA_QUEUE_EVENT_STREAMS describes all TEQ event streams in the database.
USER_QUEUE_EVENT_STREAMS describes the TEQ event streams owned by the current user.

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the queue
`NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the queue
`QUEUE_ID`	`NUMBER`	`NOT NULL`	Queue ID
`EVENT_STREAM_ID`	`NUMBER`	`NOT NULL`	Event stream ID
`DELAY_EVENT_STREAM_ID`	`NUMBER`		Delay event stream ID
`ENQUEUE_INSTANCE`	`NUMBER`	`NOT NULL`	Event stream enqueue instance ID
`EVENT_STREAM_TYPE`	`VARCHAR2(10)`		Type of event stream. Possible values: `VOLATILE` `PERSISTENT`

Note:

This view is available starting with Oracle Database 21c.