select
  k.inst_id,                               -- INST_ID NUMBER
  k.kcfiofno,                              -- FILE# NUMBER
  k.kcfiomaxdur,                           -- SINGLEBLKRDTIM_MILLI NUMBER
  k.kcfioval                               -- SINGLEBLKRDS NUMBER
from
  x$kcfiohist k,
  x$kccfe f
where
  f.fedup <> 0 and f.fenum=k.kcfiofno