Who should attend
- Database administrators
- Technical consultants
Prerequisites
- A general understanding of database administration
- Skills and knowledge commensurate with Oracle’s Database 11g: Administration Workshop I and Workshop II, or equivalent experience
Product Description
- Oracle Database 11g: Performance Tuning Methodology and Tools
- Introduction to Performance Tuning in Oracle Database 11g
- Performance Tuning Diagnostics and Tools in Oracle Database 11g
- Oracle Database 11g: Using AWR and Defining Problems
- Working with the Automatic Workload Repository (AWR)
- Defining Problems in Oracle Database 11g
- Oracle Database 11g: Metrics, Alerts, Baselines, AWR Tools and Services
- Metrics, Alerts, Baselines and Thresholds in Oracle Database 11g
- Using AWR-Based Tools
- Configuring, Managing, and Implementing Services
- Oracle Database 11g: Problem SQL Statements and Oracle Optimizer
- Identifying Problem SQL Statements
- Influencing the Oracle Query Optimizer
- Oracle Database 11g: SQL Performance Management and Database Replay
- Using SQL Performance Analyzer and SQL Performance Management
- Using Database Replay
- Oracle Database 11g: Shared Pool and Buffer Cache Tuning
- Tuning the Buffer Cache
- Using Automatic Memory Management
- Oracle Database 11g: Tuning PGA, Temporary Space, and Automatic Memory Managemen
- Tuning PGA and Temporary Space
- Using Automatic Memory Management
- Oracle Database 11g: Segment Space, I/O and Performance Tuning
- Tuning Segment Space Usage
- Tuning I/O and Performance Tuning