GV$IR_REPAIR definition in Oracle Database 11.2
GV$IR_REPAIR

select
  inst_id,                                 -- INST_ID NUMBER
  id,                                      -- REPAIR_ID NUMBER
  fid,                                     -- ADVISE_ID NUMBER
  name,                                    -- SUMMARY VARCHAR2(32)
  rank,                                    -- RANK NUMBER
  cast(ctime as date),                     -- TIME_DETECTED DATE
  cast(etime as date),                     -- EXECUTED DATE
  cast(                                    -- ESTIMATED_DATA_LOSS VARCHAR2(20)
    'UNKNOWN' as varchar2(20)),
  reco_msg,                                -- DETAILED_DESCRIPTION VARCHAR2(1024)
  script,                                  -- REPAIR_SCRIPT VARCHAR2(512)
  est_rtime,                               -- ESTIMATED_REPAIR_TIME NUMBER
  act_rtime,                               -- ACTUAL_REPAIR_TIME NUMBER
  decode(                                  -- STATUS VARCHAR2(7)
    status, 0, 'NOT RUN', 1, 'RUNNING', 2, 'SUCCESS', 3, 'FAILED', 'UNKNOWN') 
from
  x$dbkreco
where
  type = 1

home |  up