Are you sure that buffer busy waits are negatively affecting performance? I'd suggest that you perform an extended trace of some typical application operations (using dbms_support), and analyze the formatted trace file to see just how much elapsed time buffer busy waits are consuming. If they do turn out to constitute a significant percentage of elapsed time, you'll have to diagnose the reasons that certain blocks have such a high degree of concurrent access, possibly leading to changes in your application. Of course, if you're unable to change the application, you may have to do what mitigation you can in the database alone. For example, if the contention is for index blocks, and the index is based on an ascending sequence, replacing the conventional index with a reverse-key index will distribute key values across more blocks, thus reducing contention.
Dig Deeper on Oracle database performance problems and tuning
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.