PART IVDatabase Tuning
CHAPTER 16Instance Tuning
Citius, Altius, Fortius—Swifter, Higher, Stronger
—Motto of the Olympic Games
Database tuning can be a complex exercise but it can be facilitated by a systematic approach. This chapter describes a systematic five-step approach to performance tuning. It also presents the most important tools provided by Oracle to help with performance tuning; Statspack is emphasized because newer tools such as AWR and ADDM require costly licenses and are not available at most sites.1 In particular, you will learn a powerful method of mining the Statspack repository for data on performance trends. This data can be graphed by using tools such as Microsoft Excel.
I highly recommend that you download and review ...