Databases Reference
In-Depth Information
10
Tuning I/O
In this chapter, we will cover:
F
Tuning at the disk level and strategies to distribute Oracle files
F
Striping objects across multiple disks
F
Choosing different RAID levels for different Oracle files
F
Using asynchronous I/O
F
Tuning checkpoints
F
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 options to tune each of them. Due to their specific use, we can see that
there is a different solution to be implemented to optimize the I/O.
At the end of this chapter, you will also see how to tune checkpoints and redo logs to
optimize according to their related disk activities.
