GV$FILESTAT definition in Oracle Database 11.2
GV$FILESTAT

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

home |  up