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_STREAMSdescribes all TEQ event streams in the database.USER_QUEUE_EVENT_STREAMSdescribes the TEQ event streams owned by the current user.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
| Owner of the queue |
|
|
| Name of the queue |
|
|
| Queue ID |
|
|
| Event stream ID |
|
|
| Delay event stream ID |
|
|
| Event stream enqueue instance ID |
|
|
| Type of event stream. Possible values:
|
Note:
This view is available starting with Oracle Database 21c.
See Also:
“DBA_QUEUE_EVENT_STREAMS”
“USER_QUEUE_EVENT_STREAMS”
Oracle Database Advanced
Queuing User’s Guide for more information about Oracle Transactional Event Queues and Advanced Queuing
编辑：广州明生医药有限公司
标签：队列,事件,权限,信息,英文