select
  inst_id,                                 -- INST_ID NUMBER
  bfrid,                                   -- RECID NUMBER
  bfstm,                                   -- STAMP NUMBER
  bfbss,                                   -- SET_STAMP NUMBER
  bfbsc,                                   -- SET_COUNT NUMBER
  bfdfp,                                   -- FILE# NUMBER
  to_number(bfcrs),                        -- CREATION_CHANGE# NUMBER
  to_date(                                 -- CREATION_TIME DATE
    bfcrt,'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'),
  to_number(bfrls),                        -- RESETLOGS_CHANGE# NUMBER
  to_date(                                 -- RESETLOGS_TIME DATE
    bfrlc,'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'),
  decode(                                  -- INCREMENTAL_LEVEL NUMBER
    bitand(bfflg,1+8),1,bflvl,NULL),
  to_number(bfics),                        -- INCREMENTAL_CHANGE# NUMBER
  to_number(bfcps),                        -- CHECKPOINT_CHANGE# NUMBER
  to_date(                                 -- CHECKPOINT_TIME DATE
    bfcpt,'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'),
  to_number(bfafs),                        -- ABSOLUTE_FUZZY_CHANGE# NUMBER
  bfncb,                                   -- MARKED_CORRUPT NUMBER
  bfmcb,                                   -- MEDIA_CORRUPT NUMBER
  bflcb,                                   -- LOGICALLY_CORRUPT NUMBER
  bffsz,                                   -- DATAFILE_BLOCKS NUMBER
  bfbct,                                   -- BLOCKS NUMBER
  bfbsz,                                   -- BLOCK_SIZE NUMBER
  bflor,                                   -- OLDEST_OFFLINE_RANGE NUMBER
  to_date(                                 -- COMPLETION_TIME DATE
    bftsm, 'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'),
  decode(                                  -- CONTROLFILE_TYPE VARCHAR2(1)
    bfdfp, 0, decode(bitand(bfflg,2),2,'S','B'), NULL),
  decode(                                  -- USED_CHANGE_TRACKING VARCHAR2(3)
    bitand(bfflg,4),4,'YES','NO'),
  bfbrd,                                   -- BLOCKS_READ NUMBER
  decode(                                  -- USED_OPTIMIZATION VARCHAR2(3)
    bitand(bfflg,16),16,'YES','NO'),
  bffdi,                                   -- FOREIGN_DBID NUMBER
  decode(                                  -- PLUGGED_READONLY VARCHAR2(3)
    bitand(bfflg,32),0,'NO','YES'),
  bfplus,                                  -- PLUGIN_CHANGE# NUMBER
  bfprls,                                  -- PLUGIN_RESETLOGS_CHANGE# NUMBER
  bfprlt,                                  -- PLUGIN_RESETLOGS_TIME DATE
  bfssz,                                   -- SECTION_SIZE NUMBER
  decode(                                  -- UNDO_OPTIMIZED VARCHAR2(3)
    bitand(bfflg,128),0,'NO','YES'),
  bfssb                                    -- BLOCKS_SKIPPED_IN_CELL NUMBER
from
  x$kccbf
where
  bitand(bfflg, 64) != 64