Oracle教程 2023-04-06

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

本站中文解释

Oracle视图V$HM_CHECK用于检查和诊断数据库协调程序(Coordination)。当检测到已指定的异常时，系统会记录一条记录在V$HM_CHECK视图中，来帮助诊断故障。此视图显示了系统正在完成的操作，并且还显示了发生异常时的上下文和异常。通过查看V$HM_CHECK的每一行记录，可以诊断数据库的自治机制协调程序的工作。

使用Oracle视图V$HM_CHECK非常简单，可以直接SELECT * FROM V$HM_CHECK查看之前发生的协调程序异常。此外，也可以根据需要添加一些WHERE子句来进行相应的过滤，从而获得更精准的查询结果。

官方英文解释

V$HM_CHECK displays information about all the checks registered with Health Monitor. Each check is uniquely identified by a name or an ID.

Column	Datatype	Description
`ID`	`NUMBER`	Health check ID
`NAME`	`VARCHAR2(64)`	Health check name
`NAME_NLS`	`VARCHAR2(1024)`	Internationalized names of the health checks
`CLSID`	`NUMBER`	Class ID to which this check belongs
`CLS_NAME`	`VARCHAR2(15)`	Class name of the check: `GENERIC` `PERSISTENT_DATA`
`FLAGS`	`NUMBER`	Reserved for internal use
`INTERNAL_CHECK`	`VARCHAR2(1)`	Internal check
`OFFLINE_CAPABLE`	`VARCHAR2(1)`	Ability to run when database is not open yet (Y or N)
`DESCRIPTION`	`VARCHAR2(1024)`	Description of what the check does
`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

数据运维技术 » Oracle 视图 V$HM_CHECK 官方解释，作用，如何使用详细说明

分享到：

本站中文解释

官方英文解释

相关推荐