--

-- Show Total IO for Each Datafile.

--

SET PAUSE ON

SET PAUSE 'Press Return to Continue'

SET PAGESIZE 60

SET LINESIZE 300

COLUMN "File Name" FORMAT A50

SELECT Substr(d.name,1,50) "File Name",

       f.phyblkrd "Blocks Read",

       f.phyblkwrt "Blocks Writen",

       f.phyblkrd + f.phyblkwrt "Total I/O"

FROM   v$filestat f,

       v$datafile d

WHERE  d.file# = f.file#

ORDER BY f.phyblkrd + f.phyblkwrt DESC

/