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