Course Topics

• Basic Tuning Diagnostics
• Using Metrics and Alerts
• Using AWR-Based Tools
• Monitoring Applications
• Influencing the Optimizer
• Using SQL Performance Analyzer
• Using Database Replay
• Tuning the Buffer Cache
• Using Automatic Memory
• Using the Database Resource Manager
• Using Automatic Workload Repository
• Using Baselines
• Monitoring Real-Time Database Operation
• Identifying Problem SQL Statements
• Reducing the Cost of SQL Operations
• SQL Performance Management
• Tuning the Shared Pool
• Tuning PGA and Temporary Space
• Tuning I/O