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.
Duration 21 hours (3 days)
Course Outline
Introduction to SQL Tuning
- Overview of performance tuning objectives and goals
- Introduction to the Oracle Optimizer architecture
- Core tuning principles: cost, cardinality, and selectivity
Interpreting Execution Plans
- Methods for generating and analyzing execution plans
- Comparison between EXPLAIN PLAN and DBMS_XPLAN
- Identifying common performance issues within plans
Indexing Strategies
- Different index types and their impact on tuning
- Designing and evaluating indexes for optimal performance
- Application of invisible and function-based indexes
Oracle Tuning Tools
- Utilizing the Automatic Workload Repository (AWR)
- Leveraging the Automatic Database Diagnostic Monitor (ADDM)
- Employing the SQL Tuning Advisor and SQL Access Advisor
SQL Plan Management
- Establishing plan baselines and capturing execution plans
- Managing the evolution of SQL plans
- Implementation of SQL plan directives
Advanced SQL Tuning Techniques
- Addressing bind peeking and adaptive cursor sharing
- Using hints and profiles to regulate execution behavior
- Troubleshooting and optimizing complex queries
Hands-On Tuning Scenarios
- Evaluating real-world SQL performance issues
- Executing step-by-step tuning drills
- Reviewing best practices and tuning checklists
Summary and Next Steps
Requirements
- Proficiency in Oracle SQL and PL/SQL
- Practical experience with Oracle Database in the role of a developer or DBA
- Foundational knowledge of execution plans and indexing concepts
Target Audience
- Oracle database developers
- Performance engineers
- Database administrators
Testimonials (1)
good explanation on each points and provide assignment for practices.
