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