This brings us to the end of a wide variety of performance diagnosis topics. Most people in IT think Oracle performance optimization is centered on superior Oracle internals knowledge. I disagree. I believe those who use a solid method, perform a spot-on diagnosis, and then appropriately apply Oracle internals are less likely to guess and much more likely to be successful performance firefighters.

We have come to the end of the performance diagnosis and methods chapters. Now it's finally time to begin digging deep into Oracle internals!

1 If you are a queuing theory wiz, based upon the number of CPU cores, the utilization, and the run queue, you can mathematically predict how much time the Oracle processes sat in the run queue and how much time they were actually being served by a CPU core. Cool stuff, but the not the focus on this chapter. If this seems interesting to you, considering reading my book Forecasting Oracle Performance (Apress, 2007).