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:
Post a Comment