Tuesday, March 5, 2013

Calculate I/O Timing values for datafile


select f.file#,d.name,PHYRDS,PHYWRTS,READTIM/PHYRDS, WRITETIM/PHYWRTS
from v$filestat f, v$datafile d
where f.file#=d.file#
order by readtim/phyrds desc

Display the physical read physical writes and the time required, average, to complete single read or write.

No comments: