Oracle教程 2023-02-24

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

Oracle视图V$EQ_UNCACHED_PARTITIONS用于跟踪EQ Suite优化的分区。它报告EQ Suite使用的分区，而不是加载进缓存的分区(V$EQ_CACHED_PARTITIONS)。

它主要有4个字段：

OBJECT_ID：要优化的对象的标识符。
PARTITION_ID：要优化的分区的标识符。
CACHE_BITS：缓存的位掩码。
WILL_CACHE：指示EQ Suite以后是否加载分区以提供更快的访问。

V$EQ_UNCACHED_PARTITIONS视图用来检查为了使分区优化而分配了什么或者EQ Suite优化将高速缓存什么。

V$EQ_UNCACHED_PARTITIONS describes all uncached Transactional Event Queue (TEQ) event stream partitions.

Column	Datatype	Description
`QUEUE_ID`	`NUMBER`	Queue ID
`EVENT_STREAM_ID`	`NUMBER`	Event stream ID
`PRIORITY`	`NUMBER`	Priority of the event stream partition
`EVENT_STREAM_PARTITION_ID`	`NUMBER`	Event stream partition ID
`OPT_STATE`	`VARCHAR2(19)`	Current message cache optimizer state of the event stream partition. Possible values: `EMPTY` `READY` `EVICTION_PROGRESS` `EVICTED` `UNEVICTION_PROGRESS` `PREFETCH_PROGRESS` `NEED_RELOAD` `RELOAD_PROGRESS` `NA`: Error in the message cache optimizer state of the event stream partition
`OPT_TIME`	`TIMESTAMP(3) WITH TIME ZONE`	The predicted absolute time when the event stream partition could be accessed in future
`CON_ID`	`NUMBER`	The ID of the container to which the data pertains. Possible values include: `0`: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs. `1`: This value is used for rows containing data that pertain to only the root n: Where n is the applicable container ID for the rows containing data

Note:

This view is available starting with Oracle Database 21c.