Oracle教程 2023-02-24

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

V$HM_FINDING视图Records health check findings.用于记录健康检查发现情况，可以帮助管理者识别和分析数据库存在的问题，及时采取措施来改善性能，提高可靠性，从而保证安全可靠的业务运行。

使用V$HM_FINDING视图需要执行健康检查操作，主要步骤如下：

1. 打开SQL*Plus，连接到某个数据库，然后以系统管理员身份登录。

2. 在所使用的SQL*Plus窗口中，单击“Start Database Health Monitor”，或者在SQL*Plus窗口中输入下列命令来启动数据库健康检查操作：

exec dbms_hm.run_check;

3. 等待数据库健康检查操作结束，之后将使用 V$HM_FINDING视图可以查询健康检查结果，可以根据findings字段来查看健康检查的发现情况，同时也可通过recommendations字段来查看建议的解决方法。

例如：

SELECT * FROM V$HM_FINDING;

此SQL语句可以显示出所有健康检查发现情况，方便用户识别存在问题，及时采取措施来改进性能。

V$HM_FINDING displays information about all the findings of various Health Monitor runs.

Column	Datatype	Description
`FINDING_ID`	`NUMBER`	Unique ID to represent the finding
`RUN_ID`	`NUMBER`	ID of the run that created this finding
`NAME`	`VARCHAR2(32)`	Name of the finding
`PARENT_ID`	`NUMBER`	Parent finding ID for this finding
`CHILD_COUNT`	`NUMBER`	Number of active (open) child findings, if this finding is a parent finding type
`CLASS_NAME`	`VARCHAR2(32)`	Name of the class to which this finding belongs
`TIME_DETECTED`	`TIMESTAMP(6)`	Time this finding was detected
`MODIFIED`	`TIMESTAMP(6)`	Time that this finding was last modified
`PRIORITY`	`VARCHAR2(8)`	Priority of the finding: `LOW,` `HIGH` `CRITICAL`
`STATUS`	`VARCHAR2(12)`	Status of the finding: `OPEN` `CLOSED`
`TYPE`	`VARCHAR2(13)`	Type of the finding: `INFORMATIONAL` `FAILURE`
`DESCRIPTION`	`VARCHAR2(1024)`	Description of the finding
`DAMAGE_DESCRIPTION`	`VARCHAR2(1024)`	Possible damage description of the finding
`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

分享到：