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 21. Disk IO Tuning Fundamentals

Most of the techniques we looked at in preceding chapters have been aimed at avoiding or minimizing disk IO. Tuning our SQL and PL/SQL reduces the workload demand—largely logical IO—on our database. Minimizing contention attacks the bottlenecks that might be preventing that workload demand from being processed. Optimizing memory reduces the amount of workload that translates into disk activity. If you applied the practices in the previous chapters, your physical disk demand has been minimized: now it’s time to optimize the disk subsystem to meet that demand.

Reducing IO demand should almost always come before disk tuning. Disk tuning is often expensive in terms of time, money, and database availability. ...

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