Oracle教程 2023-02-24

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

V$HM_RECOMMENDATION是Oracle Enterprise Manager Database Express中可用的一个视图，用于定期轮询V$HM_RECOMMENDATIONS检查是否有需要立即处理的推荐活动。

V$HM_RECOMMENDATION视图表中提供了关于推荐处理项概要信息，比如：推荐处理项名称、处理状态、推荐级别、创建时间和实施备注信息等。

使用方法：

1、登录Oracle Enterprise Manager Database Express。

2、点击“性能视图”，选择“V$HM_RECOMMENDATION”，查看V$HM_RECOMMENDATION视图中有哪些推荐活动。

3、点击“安全”，查看推荐的安全措施，并按要求执行必要的安全措施。

4、点击“维护”，查看推荐的维护措施，并按要求执行必要的维护措施。

5、根据不同推荐维护或安全活动，执行必要的活动。

V$HM_RECOMMENDATION displays information about all the recommendations made to various Health Monitor findings.

Column	Datatype	Description
`RECOMMENDATION_ID`	`NUMBER`	Unique ID to represent the recommendation
`FDG_ID`	`NUMBER`	Unique ID to represent either the finding ID or the finding set ID for which the recommendation was made
`RUN_ID`	`NUMBER`	ID of the run that may have generated the recommendation If the ID is 0, then the recommendations were generated by RMAN.
`NAME`	`VARCHAR2(32)`	Name of the recommendation
`TYPE`	`VARCHAR2(7)`	Type of the recommendation: `MANUAL` `REPAIR`
`RANK`	`NUMBER`	Rank of the recommendation
`TIME_DETECTED`	`TIMESTAMP(6)`	Time that the recommendation was made
`EXECUTED`	`TIMESTAMP(6)`	Time that the recommendation (repair) was implemented
`STATUS`	`VARCHAR2(7)`	Status of the recommendation (repair) execution: `NOT RUN` `RUNNING` `SUCCESS` `FAILED`
`DESCRIPTION`	`VARCHAR2(1024)`	Description of the recommendation
`REPAIR_SCRIPT`	`VARCHAR2(512)`	Location of the repair script file
`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

分享到：