About this Course
This on site company private course is adapted at the level of the participants
Participants: From 2 to 6 people
Instructor: Oracle Certified trainer
Date: According to your availability
Audience profile
The “Oracle Database 11g Performance Tuning Certified Expert” certification endorses those database administrators, support engineers, and technical consultants who have demonstrated their knowledge and skills using Oracle Database 11g automatic tuning features, including SQL Tuning Advisor, SQL Access Advisor, Automatic Workload Repository and Automatic Database Diagnostic Monitor.
Teaching Methodology
Mixed sessions of theory and practice, with description of the subjects by the trainer and experimentation in the personal computer. Exercises and role plays to practice individualized resolution.
Summary and commercial proposal
- Numbers of days: 5 days
- Software in English Version Oracle Database 11g
- Instructor: Oracle Certified trainer
- Time : 9:00 to 12:00 et 13:30 à 17:00
- Certificates: Each participant receive a BesTeam Certificate of Achievement
- Material: Performance Tuning Expert Guide. Softcopy
Course Outline:
- Performance Tuning Methodology and Tools
- Using AWR and Defining Problems
- Metrics, Alerts, Baselines, AWR Tools, and Services
- Problem SQL Statements and Oracle Optimizer
- SQL Performance Management and Database Replay
- Shared Pool and Buffer Cache Tuning
- Tuning PGA, Temporary Space, and AMM
- Segment Space, I/O, and Performance Tuning
