Oracle :: Disk I/O, Events, Waits

Datafile I/O

DATAFILE I/O NOTES:

File Name - Datafile name

Physical Reads - Number of physical reads

Reads % - Percentage of physical reads

Physical Writes - Number of physical writes

Writes % - Percentage of physical writes

Total Block I/O's - Number of I/O blocks

Use this report to identify any "hot spots" or I/O contention

select  NAME,
PHYRDS "Physical Reads",
round((PHYRDS / PD.PHYS_READS)*100,2) "Read %",
PHYWRTS "Physical Writes",
round(PHYWRTS * 100 / PD.PHYS_WRTS,2) "Write %",
fs.PHYBLKRD+FS.PHYBLKWRT "Total Block I/O's"
from (
select  sum(PHYRDS) PHYS_READS,
sum(PHYWRTS) PHYS_WRTS
from   v$filestat
) pd,
v$datafile df,
v$filestat fs
where  df.FILE# = fs.FILE#
order  by fs.PHYBLKRD+fs.PHYBLKWRT desc