News
Perth, Australia
+ (61) 417713124
prosolutions@gavinsoorma.com

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;
 

0 Comments

Leave Reply

Your email address will not be published. Required fields are marked *