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, ...

Get Oracle now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.