Chapter 10. Tuning I/O
In this chapter, we will cover:
- Tuning at the disk level and strategies to distribute Oracle files
- Striping objects across multiple disks
- Choosing different RAID levels for different Oracle files
- Using asynchronous I/O
- Tuning checkpoints
- Tuning redo logs
Introduction
In the previous chapter, we have seen some methods to tune the memory used by Oracle processes to obtain best performance from our hardware.
The database is made up of datafiles on disks; typically, I/O time from disk is slower by one order of magnitude than I/O from memory. So, tuning the disk I/O subsystem can gain significant performance improvements for the database.
In this chapter, we will see the different types of files used by the Oracle database and the available ...
Get Oracle Database 11gR2 Performance Tuning Cookbook 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.
