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 objectives.
- Essential tuning concepts: cost, cardinality, and selectivity.
Understanding Execution Plans
- Techniques for generating and interpreting execution plans.
- Comparing EXPLAIN PLAN with DBMS_XPLAN.
- Identifying common performance issues within plans.
Indexing Strategies
- Index types and their impact on tuning.
- Creating and evaluating indexes for performance enhancement.
- Implementation of 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 the process of capturing plans.
- Handling plan evolutions.
- Utilizing SQL plan directives.
Advanced SQL Tuning Techniques
- Bind peeking and adaptive cursor sharing.
- Controlling execution through hints and profiles.
- Troubleshooting and optimizing complex queries.
Hands-On Tuning Scenarios
- Examination of practical SQL challenges.
Summary and Next Steps
Requirements
- A solid grasp of Oracle SQL and PL/SQL.
- Practical experience working with Oracle Database in a developer or DBA capacity.
- Fundamental knowledge of execution plans and indexing principles.
Audience
- Oracle database developers.
- Performance engineers.
- Database administrators.
21 Hours
Testimonials (1)
good explanation on each points and provide assignment for practices.
