GV$IR_FAILURE_SET definition in Oracle Database 11.2
GV$IR_FAILURE_SET

select
  inst_id,                                 -- INST_ID NUMBER
  id,                                      -- ADVISE_ID NUMBER
  failid,                                  -- FAILURE_ID NUMBER
  decode(                                  -- MANUAL_REPAIRS_ONLY VARCHAR2(3)
    bitand(flags,8), 0, 'NO', 'YES') 
from
  x$dbkfset

home |  up