Oracle教程 2023-02-26

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

Oracle视图V$FS_FAILOVER_STATS用于显示文件系统故障转移统计信息。

它显示了文件系统故障转移操作的统计信息，包括时间段、文件系统故障转移的持续时间、在持续的时间段中失败的文件系统故障转移数量等。该视图有助于系统管理员评估文件系统故障转移的性能，以及记录文件系统故障转移的失败统计信息。

要使用视图V$FS_FAILOVER_STATS，必须有SELECT_CATALOG_ROLE和UNIX_GROUP_ROLE权限。然后可以使用SELECT子句检索视图中的结果：

例如：SELECT * FROM V$FS_FAILOVER_STATS;

V$FS_FAILOVER_STATS displays statistics about fast-start failovers occurring on the system.

Column Datatype Description

Column	Datatype	Description
`LAST_FAILOVER_TIME`	`VARCHAR2(20)`	Timestamp of the last fast-start failover
`LAST_FAILOVER_REASON`	`VARCHAR2(255)`	Reason for the last fast-start failover
`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

LAST_FAILOVER_TIME

VARCHAR2(20)

Timestamp of the last fast-start failover

LAST_FAILOVER_REASON

VARCHAR2(255)

Reason for the last fast-start failover

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

分享到：