CHAPTER 16
Database 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 given equal time because tools such as Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) require licenses and are not available at most sites.1 In particular, you learn a powerful method of mining the Statspack and AWR repositories ...
Get Beginning Oracle Database 12c Administration: From Novice to Professional, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
