Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Introduction to SQL Tuning
- Overview of performance tuning goals and objectives.
- Overview of Oracle Optimizer architecture.
- Key tuning concepts: cost, cardinality, and selectivity.
Understanding Execution Plans
- Generating and interpreting execution plans.
- EXPLAIN PLAN vs DBMS_XPLAN.
- Common performance pitfalls found in plans.
Indexing Strategies
- Index types and their implications for tuning.
- Creating and analyzing indexes for improved performance.
- Using invisible and function-based indexes.
Oracle Tuning Tools
- Automatic Workload Repository (AWR).
- Automatic Database Diagnostic Monitor (ADDM).
- SQL Tuning Advisor and SQL Access Advisor.
SQL Plan Management
- Plan baselines and capturing plans.
- Managing plan evolutions.
- Using SQL plan directives.
Advanced SQL Tuning Techniques
- Bind peeking and adaptive cursor sharing.
- Using hints and profiles to control execution.
- Diagnosing and fixing complex queries.
Hands-On Tuning Scenarios
- Analyzing real-world SQL problems.
- Step-by-step tuning exercises.
- Best practices and tuning checklists.
Summary and Next Steps
Requirements
- A solid understanding of Oracle SQL and PL/SQL.
- Experience working with Oracle Database as a developer or DBA.
- Basic familiarity with execution plans and indexing concepts.
Audience
- Oracle database developers.
- Performance engineers.
- Database administrators.
21 Hours
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 3900 € + VAT*
Contact us for an exact quote and to hear our latest promotions
