磁盘IO: 避免I/O磁盘争用，用下面的查询确定文件的I/O问题
col File_Name format a40
select
 df.name File_Name,
 fs.phyrds Reads,
 fs.phywrts Writes,
 (fs.readtim/decode(fs.phyrds,0,-1,fs.phyrds)) Read_Time,
 (fs.writetim/decode(fs.phywrts,0,-1,fs.phywrts)) Write_Time
from
 v$datafile df,
 v$filestat fs
where df.file#=fs.file#
order by df.name;


或者：
col NAME for a50
select name,phyrds,phywrts,readtim,writetim
       from v$filestat a,v$dbfile b
       where a.file# = b.file#
       order by readtim desc;