Buffer busy waits by files
                                                 Last update (2008-03-11 17:31:10)
                                                                                                                   Date added (2008-03-09 17:03:57)

Summary
The following script lists the contents of x$kcbfwait, I have eliminate files where there have been no waits.
SELECT indx+1 FILE#, d.file_name, COUNT, TIME, TIME/(DECODE(COUNT,0,1,COUNT)) AVG 
FROM x$kcbfwait, dba_data_files D
WHERE indx < (SELECT COUNT(*) FROM v$datafile) 
AND indx+1 = D.file_id
AND TIME > 0 
ORDER BY AVG DESC;
Reviews
Categories
Filters
Search