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 ...

Get Beginning Oracle Database 11g Administration: From Novice to Professional now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.