Database Tuning

  • Ignatius Fernandez


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. In particular, you learn a powerful method of mining the Statspack and AWR repositories for data on performance trends. This data can be graphed by using tools such as Microsoft Excel.


Trace File Performance Tune Oracle Database Enterprise Edition Logical Read 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Copyright information

© Ignatius Fernandez 2015

Authors and Affiliations

  • Ignatius Fernandez
    • 1
  1. 1.CAUS

Personalised recommendations