V$IR_FAILURE_SET definition in Oracle Database 11.2
V$IR_FAILURE_SET
select
ADVISE_ID, -- ADVISE_ID NUMBER
FAILURE_ID, -- FAILURE_ID NUMBER
MANUAL_REPAIRS_ONLY -- MANUAL_REPAIRS_ONLY VARCHAR2(3)
from
GV$IR_FAILURE_SET
where
inst_id=USERENV('Instance')