Script – Datafiles with highest I/O activity

• Posted by Gavin Soorma
• On July 1, 2009
• 0 Comments

col name format a40
set linesize 140
select * from (
select name,phyrds, phywrts,readtim,writetim
from v$filestat a, v$datafile b
where a.file#=b.file#
order by readtim desc) where rownum <6;