Segment related question

[Sureshy]

/* Check disk i/o per file and determine bottlenecks */

select phyrds, phywrts, d.name
from v$datafile d, v$filestat f
where d.file#=f.file#
order by d.name;