This Oracle Database 11g Performance Tuning training starts with an unknown database that requires tuning. You'll then learn the steps a DBA performs to identify problem areas, diagnose common problems and fix them.

• Introduction
• Monitoring tools overview
• Using Automatic Workload Repository
• Defining Problems
• Metrics, Alerts, and Baselines
• Comparative Performance Analysis with AWR Baselines
• Using AWR Based Tools
• Monitoring an Application
• Identifying Problem SQL Statements
• Influencing the Optimizer
• Using SQL Performance Analyzer
• SQL Performance Management
• Using Database Replay
• Tuning the Shared Pool
• Tuning the Buffer Cache
• Tuning PGA and Temporary Space
• Automatic Memory Management
• Tuning Segment Space Usage
• Tuning I/O
• Performance Tuning Summary
• Appendix B: Using Statspack

• Oracle Database 11g: Administration Workshop I Release 2
• Oracle Database 11g: Administration Workshop II Release 2