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 principles.
- Examination of Oracle Optimizer architecture.
- Core 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 pitfalls in execution plans.
Indexing Strategies
- Different index types and their impact on tuning.
- Creating and analyzing indexes for optimal performance.
- Implementing 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 plan capture methods.
- Managing plan evolution.
- Utilizing SQL plan directives.
Advanced SQL Tuning Techniques
- Bind peeking and adaptive cursor sharing.
- Controlling execution via hints and profiles.
- Diagnosing and correcting complex queries.
Hands-On Tuning Scenarios
- Analyzing real-world SQL challenges.
- 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 in a developer or DBA capacity.
- Basic familiarity with execution plans and indexing concepts.
Audience
- Oracle database developers.
- Performance engineers.
- Database administrators.
21 Hours
Testimonials (1)
good explanation on each points and provide assignment for practices.
