Oracle Datafiles Disk I/O

Datafiles Disk IO


set pagesize 100
set linesize 200
col PERC_READS format a10
col name format a40
col PERC_WRITES like PERC_READS
SELECT df.NAME, phyrds Physical_READS,
ROUND((RATIO_TO_REPORT(phyrds) OVER ())*100, 2)|| '%' PERC_READS,
phywrts Physical_WRITES,
ROUND((RATIO_TO_REPORT(phywrts) OVER ())*100, 2)|| '%' PERC_WRITES,
phyrds + phywrts total
FROM v$datafile df, v$filestat fs, ts$ t
WHERE df.FILE# = fs.FILE#
AND df.ts# = t.ts#
-- AND t.NAME = ' xxxx '
ORDER BY phyrds DESC;