V$HM_RECOMMENDATION definition in Oracle Database 11.2
V$HM_RECOMMENDATION
select
RECOMMENDATION_ID, -- RECOMMENDATION_ID NUMBER
FDG_ID, -- FDG_ID NUMBER
RUN_ID, -- RUN_ID NUMBER
NAME, -- NAME VARCHAR2(32)
TYPE, -- TYPE VARCHAR2(7)
RANK, -- RANK NUMBER
TIME_DETECTED, -- TIME_DETECTED TIMESTAMP(6)
EXECUTED, -- EXECUTED TIMESTAMP(6)
STATUS, -- STATUS VARCHAR2(7)
DESCRIPTION, -- DESCRIPTION VARCHAR2(1024)
REPAIR_SCRIPT -- REPAIR_SCRIPT VARCHAR2(512)
from
GV$HM_RECOMMENDATION
where
inst_id=USERENV('Instance')