D50317 – Oracle Database 11g: Performance Tuning DBA

• Duration: 10 weeks

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