Busy Buffer Waits per file
SET LINESIZE 145
SET PAGESIZE 9999
COLUMN filename FORMAT a58 HEAD "File Name"
COLUMN file# FORMAT 999 HEAD "File #"
COLUMN ct FORMAT 999,999,999 HEAD "Waits (count)"
COLUMN time FORMAT 999,999,999 HEAD "Time (cs)"
COLUMN avg FORMAT 999.999 HEAD "Avg Time"
SELECT
a.indx + 1 file#
, b.name filename
, a.count ct
, a.time time
, a.time/(DECODE(a.count,0,1,a.count)) avg
FROM
x$kcbfwait a
, v$datafile b
WHERE
indx < (SELECT count(*) FROM v$datafile)
AND a.indx+1 = b.file#
ORDER BY a.time
/