Oracle Scratchpad

November 21, 2006

Free Buffer Waits

Filed under: Execution plans, Infrastructure, Troubleshooting — Jonathan Lewis @ 8:53 am UTC Nov 21,2006

I think that many DBAs are likely to be familar with the event “free buffer waits” and recognise it as an indication that DBWR (the database writer) is not clearing the buffer cache of dirty blocks fast enough. But that’s not the only cause of free buffer waits.

(more…)

Blog at WordPress.com.