Oracle教程

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

本站中文解释

Oracle 视图 V$HM_INFO 是用于检索系统健康检查信息的数据字典视图。它可显示系统健康检查操作的状态、IP 地址、结果摘要和详细情况。

V$HM_INFO 视图的使用主要用于以交互或非交互的方式显示系统健康检查信息。它可以用来查询系统健康检查的进度、完成情况和任何意外完成时出现的结果摘要和详情信息。可以用简单的SQL语句查询V$HM_INFO视图：

例如，下面的语句可以用来检索最近一次健康检查的详细结果：

SELECT *
FROM V$HM_INFO
WHERE HM_TIMESTAMP = (SELECT MAX(HM_TIMESTAMP) FROM V$HM_INFO);

官方英文解释

V$HM_INFO displays information about Health Monitor runs, findings, and recommendations.

The information for a run/finding/recommendation is organized as a name, value pair.

If the type of information is RUN, then the data represents the input parameters for that run. If the type of information is FINDING or RECOMMENDATION, then the data represents the information about that particular finding/recommendation.

Column Datatype Description

ID

NUMBER

Unique identifier of the information

TYPE

VARCHAR2(14)

Type of the information:

  • RUN

  • RUN-RESUME

  • FINDING

  • RECOMMENDATION

NAME

VARCHAR2(32)

Information parameter name

VALUE

VARCHAR2(513)

Information parameter value

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_INFO 官方解释，作用，如何使用详细说明
分享到：

相关推荐