Total I/O Per Datafile

This script is used to check the total I/O per datafile and tablespace

SELECT t.name tablespace,
dbfile_name,
total_io,
phyblkrd,
phyblkwrt
FROM v$tablespace t,
(SELECT TS#,
df.name dbfile_name,
fs.phyblkrd + fs.phyblkwrt total_io,
fs.phyblkrd,
fs.phyblkwrt
FROM v$filestat fs,
v$datafile df,
(SELECT MAX (phyblkrd + phyblkwrt) maxio FROM v$filestat)
WHERE df.file# = fs.file#) d
WHERE t.TS# = d.TS#
ORDER BY t.name,total_io DESC;