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')

home |  up