Topics to be Covered: 

• Overview of Performance Management
• Optimization Methodology
• Oracle Performance Data Dictionary Views
• Identifying Database Bottlenecks
• Overview of AWR
• Low-Level Tracing - Event 10046
• The Oracle Optimizer
• Analyzing Execution Plans
• Locks and Latches
• The Oracle Optimizer
• Understanding the Oracle Optimizer - Event 10053
• Histograms - Use of METHOD_OPT
• Hints
• Stored Outlines
• Table and Index Monitoring
• Optimizing Storage Configuration
• RAID
• ASM
• Designing for Performance
• Database Design and Normalization
• Best Practices
• Parallel Processing
• Optimizing Bulk Operations
• Overview of Clustered Architecture
• Performance Data Dictionary Views
• General Performance Considerations for RAC
• Miscellaneous Topics
• Optimizing Backup and Recovery Operations
• Benefits of Native Compilation
  
• Oracle Network Compilation
• Resource Manager
• External Tables
• Shared Server Architecture (Multithreaded Server)
  

 Class Tuition: $1,500 per person *