GV$HM_RECOMMENDATION definition in Oracle Database 11.2
GV$HM_RECOMMENDATION
select
inst_id, -- INST_ID NUMBER
id, -- RECOMMENDATION_ID NUMBER
fid, -- FDG_ID NUMBER
runid, -- RUN_ID NUMBER
name, -- NAME VARCHAR2(32)
decode( -- TYPE VARCHAR2(7)
type, 0, 'MANUAL', 1, 'REAPIR', 'UNKNOWN'),
rank, -- RANK NUMBER
cast(ctime as timestamp), -- TIME_DETECTED TIMESTAMP(6)
cast(etime as timestamp), -- EXECUTED TIMESTAMP(6)
decode( -- STATUS VARCHAR2(7)
status, 0, 'NOT RUN', 1, 'RUNNING', 2, 'SUCCESS', 3, 'FAILED', 'UNKNOWN'),
reco_msg, -- DESCRIPTION VARCHAR2(1024)
script -- REPAIR_SCRIPT VARCHAR2(512)
from
x$dbkreco