select
  FAILURE_ID,                              -- FAILURE_ID NUMBER
  PARENT_ID,                               -- PARENT_ID NUMBER
  CHILD_COUNT,                             -- CHILD_COUNT NUMBER
  CLASS_NAME,                              -- CLASS_NAME VARCHAR2(32)
  TIME_DETECTED,                           -- TIME_DETECTED DATE
  MODIFIED,                                -- MODIFIED DATE
  DESCRIPTION,                             -- DESCRIPTION VARCHAR2(1024)
  IMPACTS,                                 -- IMPACTS VARCHAR2(1024)
  PRIORITY,                                -- PRIORITY VARCHAR2(8)
  STATUS                                   -- STATUS VARCHAR2(12)
from
  GV$IR_FAILURE
where
  inst_id=USERENV('Instance')