D50317 – Oracle Database 11g: Performance Tuning DBA

• Duration: 5 days

Curriculum

• Module 1: Introduction
• Module 2: Monitoring With Basic Tools
• Module 3: Using Automatic Workload Repository
• Module 4: Identifying the Problem
• Module 5: Identifying Problem SQL Statements
• Module 6: Influencing the Optimizer
• Module 7: SQL Plan Management
• Module 8: Change Management
• Module 9: Using Metrics and Alerts
• Module 10: Using AWR Based Tools
• Module 11: Monitoring an Application (Using Services)
• Module 12: Baselines
• Module 13: Tuning the Shared Pool
• Module 14: Tuning the Buffer Cache
• Module 15: Tuning PGA and Temporary Space
• Module 16: Automatic Memory Management
• Module 17: Tuning Block Space Usage
• Module 18: Tuning I/O
• Module 19: Performance Tuning: Summary
• Module 20: Using Statspack