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