V$HM_RECOMMENDATION

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