Avgiotim

From: steve <holdersav_at_blueyonder.co.uk>
Date: 5 Feb 2003 04:29:14 -0800
Message-ID: <567eb881.0302050429.144b9fab@posting.google.com>

Does anyone know how the avgiotim and why comparing it to the phyrds/phywrts/readtim/writetim is so different e.g.

select

	file#,
	phyrds,
	phyblkrd,
	round(readtim/decode(phyrds,0,1,phyrds),3)	readtim,
	phywrts,
	phyblkwrt,
	round(writetim/decode(phywrts,0,1,phywrts),3)	writetim,

  round((readtim+writetim)/(phyrds+phywrts),3) calc,   avgiotim   

from v$filestat
where file#=18
order by file#
;

                    AvgReadtime             AvgWriteTime   Calc  
Avgio
1 18	3673	3673	0.1	3455	3455	0	   0.051   32

Thanks Received on Wed Feb 05 2003 - 06:29:14 CST