Oracle教程 2023-02-27

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

V$HVMASTER_INFO 视图是Oracle容错架构的一部分，

它提供了给定互操作数据库中启用的主编号(HVMasterNumber)和全局目录(Global DB Name)的信息，以便用户可以快速检查现有的容错环境信息。

使用此视图可以获取当前正在运行的数据库的主编号，并检查以及检查当前用户所需的容错结构的正确配置，以正确利用容错功能。

用法：

SELECT * FROM v$hvmaster_info;

V$HVMASTER_INFO describes the current and previous master instances and the number of re-masterings of Global Enqueue Service resources.

Column	Datatype	Description
`HV_ID`	`NUMBER`	Hash value ID
`CURRENT_MASTER`	`NUMBER`	Master instance of this hash value ID
`PREVIOUS_MASTER`	`NUMBER`	Previous master instance of this hash value ID
`REMASTER_CNT`	`NUMBER`	Number of times this has been remastered
`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

分享到：