O'Reilly logo

Oracle by Guy Harrison

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 18. Buffer Cache Tuning

In the preceding chapters, we discussed how to reduce the demand placed on the Oracle database through application design and SQL tuning. We then proceeded to eliminate contention preventing Oracle from processing that demand. Our objective has been to minimize the logical IO demand that is sent from the application to Oracle and remove any obstacles that block that demand.

If we’ve done a good job so far, we have achieved a logical IO rate that is at a realistic level for the tasks that the application must perform. Now it’s time to try to prevent as much as possible of that logical IO from turning into physical IO. Remember, no matter how much you optimize your IO subsystem, disk IO will still be orders of magnitude, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required