Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning

In a Nutshell

I/O operations are a necessity of every process that reads from or writes to the database. Database reads and writes are simple on the surface, but the path between the database and the physical disks can be a convoluted mess of software and hardware from various manufacturers, each with its own limitations. With all the handshakes that have to take place, it is a miracle that you get your data accurately! Although a DBA is not required to know the hardware layer intimately, a good knowledge of the system will definitely help you better manage the database and enrich your database administration experience.

In this chapter, we covered seven common I/O related wait events: db file sequential read, db file scattered read, direct path ...