Oracle教程 2023-02-24

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

Oracle视图V$EQ_INACTIVE_PARTITIONS用于查看不可用于数据存取的表空间分区及段。它返回有关被定义但不可使用作为表空间分区或与其相关联段的信息。

使用方法：

1. 首先，使用下面的查询语句检索V$EQ_INACTIVE_PARTITIONS中的信息：

SELECT * FROM V$EQ_INACTIVE_PARTITIONS;

2. 查看V$EQ_INACTIVE_PARTITIONS视图中的记录，以获取被停用的表空间分区及段的具体信息。

3. 如果要修复停用的表空间分区，可以使用ALTER TABLE … DROP PARTITION语句将其彻底删除，然后使用ALTER TABLE … ADD PARTITION语句重新创建该分区。

V$EQ_INACTIVE_PARTITIONS describes all inactive Transactional Event Queue (TEQ) event stream partitions.

Column	Datatype	Description
`QUEUE`	`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` `CACHED` `EVICTION_PROGRESS` `EVICTED` `UNEVICTION_PROGRESS` `PREFETCH_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.