* Chapter 5, Oracle Performance Diagnosis: This chapter rounds out and digs very deep into, among other things, gathering performance statistics, avoiding myths and pitfalls, dealing with the realities of modern Oracle architectures, and taking advantage of advanced Oracle data collection capabilities. It also introduces Oracle's built-in kernel-level data collector, known as active session history, or ASH for short.

* Chapter 6, Oracle Buffer Cache Internals: Oracle's buffer cache operation must be smooth, contention-free, and speedy for optimal performance. There are a large number of Oracle wait events surrounding the buffer cache. The buffer cache is an amazing Oracle technical accomplishment, and it's our job to ensure it is running optimally. I will go deep into the key algorithms, including how to diagnose real problems and resolve them.

* Chapter 7, Oracle Shared Pool Internals: Oracle's shared pool is extremely complex and can have significant performance problems. The shared pool contains a large number of different memory structures, each with unique characteristics that must relate to potentially many other shared pool structures. In this chapter, I take a divide-and-conquer approach to ensure the problem is correctly diagnosed, and the related structures and algorithms are understood, so that the solutions naturally present themselves (really).