Oracle教程 2023-02-24

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

视图

Oracle视图V$CORRUPT_XID_LIST可以显示数据库中存在损坏的事务ID (XID)的信息。损坏的XID可能是由于各种因素导致，例如由于宕机而发生的故障恢复过程，以及恶意攻击或者数据库软件错误等。

要使用此视图，可以执行以下查询：
SELECT * FROM V$CORRUPT_XID_LIST;

此查询将返回表中可用的XID的信息。查看这些XID可以让 DBA 了解损坏的XID的数量及其位置，从而可以确定数据库中发生的损坏的程度，从而能够采取进一步的措施，如回滚或删除这些损坏的XID等。

V$CORRUPT_XID_LIST displays all corrupted XIDs.

Column Datatype Description

Column	Datatype	Description
`CORRUPT_XID`	`VARCHAR2(256)`	Name of corrupt XID
`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

CORRUPT_XID

VARCHAR2(256)

Name of corrupt XID

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

分享到：