select
  REPAIR_ID,                               -- REPAIR_ID NUMBER
  ADVISE_ID,                               -- ADVISE_ID NUMBER
  SUMMARY,                                 -- SUMMARY VARCHAR2(32)
  RANK,                                    -- RANK NUMBER
  TIME_DETECTED,                           -- TIME_DETECTED DATE
  EXECUTED,                                -- EXECUTED DATE
  ESTIMATED_DATA_LOSS,                     -- ESTIMATED_DATA_LOSS VARCHAR2(20)
  DETAILED_DESCRIPTION,                    -- DETAILED_DESCRIPTION VARCHAR2(1024)
  REPAIR_SCRIPT,                           -- REPAIR_SCRIPT VARCHAR2(512)
  ESTIMATED_REPAIR_TIME,                   -- ESTIMATED_REPAIR_TIME NUMBER
  ACTUAL_REPAIR_TIME,                      -- ACTUAL_REPAIR_TIME NUMBER
  STATUS                                   -- STATUS VARCHAR2(7)
from
  GV$IR_REPAIR
where
  inst_id=USERENV('Instance')