select inst_id, -- INST_ID NUMBER decode( -- STATUS VARCHAR2(7) bitand(cfflg,1),0,'',1,'INVALID'), cfnam, -- NAME VARCHAR2(513) decode( -- IS_RECOVERY_DEST_FILE VARCHAR2(3) bitand(cffl2,1),0,'NO','YES'), cfbsz, -- BLOCK_SIZE NUMBER cffsz -- FILE_SIZE_BLKS NUMBER from x$kcccf