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 and objectives of performance tuning
- Architectural overview of the Oracle Optimizer
- Essential tuning concepts: cost, cardinality, and selectivity
Interpreting Execution Plans
- Generating and analyzing execution plans
- Comparison of EXPLAIN PLAN and DBMS_XPLAN
- Identifying common performance issues within plans
Indexing Strategies
- Various index types and their impact on tuning
- Creating and evaluating indexes for performance enhancement
- Implementing invisible and function-based indexes
Oracle Tuning Utilities
- Automatic Workload Repository (AWR)
- Automatic Database Diagnostic Monitor (ADDM)
- SQL Tuning Advisor and SQL Access Advisor
SQL Plan Management
- Plan baselines and the process of capturing plans
- Oversight of plan evolution
- Application of SQL plan directives
Advanced SQL Tuning Techniques
- Bind peeking and adaptive cursor sharing
- Controlling execution using hints and profiles
- Diagnosing and resolving complex queries
Hands-On Tuning Scenarios
- Analysis of practical SQL issues
- Guided tuning exercises step-by-step
- Industry best practices and tuning checklists
Summary and Next Steps
Requirements
- Proficiency in Oracle SQL and PL/SQL
- Practical experience with Oracle Database in a development or DBA capacity
- Fundamental knowledge of execution plans and indexing principles
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
Testimonials (1)
good explanation on each points and provide assignment for practices.
