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
Course Outline
Introduction to SQL Tuning Principles
- Overview of performance tuning objectives and goals
- Core tuning metrics: cost, cardinality, and selectivity
Analyzing Execution Plans
- Techniques for generating and deciphering execution plans
- Comparison between EXPLAIN PLAN and DBMS_XPLAN
- Identifying common performance issues within plans
Effective Indexing Strategies
- Types of indexes and their impact on tuning
- Designing and evaluating indexes for optimal performance
- Utilizing invisible indexes and function-based indexes
Oracle Performance Tools
- Leveraging the Automatic Workload Repository (AWR)
- Utilizing the Automatic Database Diagnostic Monitor (ADDM)
- Working with the SQL Tuning Advisor and SQL Access Advisor
SQL Plan Management
- Creating and maintaining plan baselines
- Managing plan evolution processes
Advanced SQL Optimization Techniques
- Handling bind peeking and adaptive cursor sharing
- Controlling execution via hints and SQL profiles
- Troubleshooting and refining complex queries
Practical Tuning Scenarios
- Analyzing and resolving real-world SQL performance issues
- Executing detailed, step-by-step tuning exercises
Conclusion and Future Steps
Requirements
- Solid comprehension of Oracle SQL and PL/SQL
- Professional experience with Oracle Database, either as a developer or DBA
- Foundational knowledge of execution plans and indexing principles
Target Audience
- Performance engineers
- Database administrators
Testimonials (1)
good explanation on each points and provide assignment for practices.
