select
k.inst_id, -- INST_ID NUMBER
k.kcfiofno, -- FILE# NUMBER
k.kcfiopyr, -- PHYRDS NUMBER
k.kcfiopyw, -- PHYWRTS NUMBER
k.kcfiopbr, -- PHYBLKRD NUMBER
k.kcfiofbr, -- OPTIMIZED_PHYBLKRD NUMBER
k.kcfiopbw, -- PHYBLKWRT NUMBER
k.kcfiosbr, -- SINGLEBLKRDS NUMBER
round(k.kcfioprt / 10000), -- READTIM NUMBER
round(k.kcfiopwt / 10000), -- WRITETIM NUMBER
round(k.kcfiosbt / 10000), -- SINGLEBLKRDTIM NUMBER
round(k.kcfioavg / 10000), -- AVGIOTIM NUMBER
round(k.kcfiolst / 10000), -- LSTIOTIM NUMBER
round(k.kcfiomin / 10000), -- MINIOTIM NUMBER
round(k.kcfiormx / 10000), -- MAXIORTM NUMBER
round(k.kcfiowmx / 10000) -- MAXIOWTM NUMBER
from
x$kcfio k,
x$kccfe f
where
f.fedup <> 0 and f.fenum=k.kcfiofno