Oracle教程 2023-02-26

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

Oracle视图V$HM_RUN视图主要用于查看与Oracle Health Monitor有关的状态或信息。

Oracle Health Monitor旨在通过管理监控器来收集数据库和应用服务器状态和信息，以帮助诊断、故障定位、性能调整等目的。该视图存储有关以下内容的信息：

1、正在进行的监视及每个监视器运行状态；

2、每个监视器最近一次启动和完成时间；

3、监视器最近一次启动和完成是否成功；

4、监视器运行次数。

使用方法：

可以使用以下SQL语句查看V$HM_RUN视图的相关信息：

SELECT * FROM V$HM_RUN;

此外，也可以根据四个字段（MON_ID，LAST_START_TIME，LAST_END_TIME，STATE）来获取更加细致的信息：

SELECT MON_ID, LAST_START_TIME, LAST_END_TIME, STATE FROM V$HM_RUN;

V$HM_RUN displays information about all Health Monitor checks and their status.

Column	Datatype	Description
`RUN_ID`	`NUMBER`	Unique ID to represent the run
`NAME`	`VARCHAR2(32)`	Unique name used to identify the run
`CHECK_NAME`	`VARCHAR2(32)`	Name of the check
`RUN_MODE`	`VARCHAR2(8)`	Mode of the run: `MANUAL` `REACTIVE` `AUTO`
`TIMEOUT`	`NUMBER`	Number of seconds allowed for this run to complete before it is aborted
`START_TIME`	`TIMESTAMP(6)`	Start time of the run
`LAST_RESUME_TIME`	`TIMESTAMP(6)`	Last resumed time for the run
`END_TIME`	`TIMESTAMP(6)`	End time of the run
`MODIFIED_TIME`	`TIMESTAMP(6)`	Last modified time of the run record
`STATUS`	`VARCHAR2(11)`	Status of the run: `INITIAL` `EXECUTING` `INTERRUPTED` `TIMEDOUT` `CANCELLED` `COMPLETED` `ERROR`
`SRC_INCIDENT`	`NUMBER`	Source incident ID that activated this run
`NUM_INCIDENT`	`NUMBER`	Number of incidents created by this run
`ERROR_NUMBER`	`NUMBER`	Error number if the run failed to complete because of an error
`PROBLEM_ID`	`NUMBER`	Problem ID of the source incident ID that may have activated this Run
`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

分享到：