select
  k.inst_id,                               -- INST_ID NUMBER
  k.kcftiofno,                             -- FILE# NUMBER
  k.kcftiopyr,                             -- PHYRDS NUMBER
  k.kcftiopyw,                             -- PHYWRTS NUMBER
  k.kcftiopbr,                             -- PHYBLKRD NUMBER
  k.kcftiopbw,                             -- PHYBLKWRT NUMBER
  k.kcftiosbr,                             -- SINGLEBLKRDS NUMBER
  round(k.kcftioprt / 10000),              -- READTIM NUMBER
  round(k.kcftiopwt / 10000),              -- WRITETIM NUMBER
  round(k.kcftiosbt / 10000),              -- SINGLEBLKRDTIM NUMBER
  round(k.kcftioavg / 10000),              -- AVGIOTIM NUMBER
  round(k.kcftiolst / 10000),              -- LSTIOTIM NUMBER
  round(k.kcftiomin / 10000),              -- MINIOTIM NUMBER
  round(k.kcftiormx / 10000),              -- MAXIORTM NUMBER
  round(k.kcftiowmx / 10000)               -- MAXIOWTM NUMBER
from
  x$kcftio k,
  x$kcctf f
where
  f.tfdup <> 0 and f.tfnum=k.kcftiofno