Diagnostic and Tuning Tools

After completing this lesson, you should be able to do the following: Identify key tuning components of the alert log file Identify key tuning components of backgroundtrace files Identify key tuning components of user trace files Collect statistics with Oracle Enterprise Manager Describe how Statspack collects statistics Collect statistics with Statspack Identify dynamic performance views useful in tuning Describe other tools used for tuning