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')

home |  up