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