io统计.sql

介绍oracle dba常用的报表代码,已经异常查找等

----I/O统计1.
select substr(DF.Name, 1, 5) Drive,
       SUM(FS.Phyblkrd + FS.Phyblkwrt) Total_IOs,
       SUM(FS.Phyblkrd) Blocks_Read,
       SUM(FS.Phyblkwrt) Blocks_Written
  from V$FILESTAT FS, V$DATAFILE DF
 where DF.File# = FS.File#
 group by substr(DF.Name, 1, 5)
 order by Total_IOs desc;
----I/O统计2.
select substr(DF.Name, 1, 5) Drive,
       DF.Name File_Name,
       FS.Phyblkrd + FS.Phyblkwrt Total_IOs,
       FS.Phyblkrd Blocks_Read,
       FS.Phyblkwrt Blocks_Written
  from V$FILESTAT FS, V$DATAFILE DF
 where DF.File# = FS.File#
 order by Drive, File_Name desc;