Tuning

[hacketta1]

Do you have a performance problem? Do you have evidence that those wait events are causing the performance problem? On the database I look after buffer busy waits are always in my top 5 wait events yet whenever I trace a performance issue I find that buffer busy waits contribute a tiny amount to the overall runtime duration of the session. I could try to eliminate those buffer busy waits, but the performance problem will still be there after I've finished. There's no point dealing with these if there are bigger fish to fry. Make sure you're dealing with the cause of a problem before worrying about it would be my advice.