Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

Part Number E10820-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

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