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

home |  up