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 and goals
- Architectural overview of the Oracle Optimizer
- Core tuning concepts: cost, cardinality, and selectivity
Interpreting Execution Plans
- Generation and interpretation of execution plans
- Comparison of EXPLAIN PLAN and DBMS_XPLAN
- Identification of common performance issues within plans
Indexing Strategies
- Various index types and their impact on tuning
- Index creation and analysis for enhanced performance
- 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
- Oversight of plan evolutions
- Application of SQL plan directives
Advanced SQL Tuning Techniques
- Bind peeking and adaptive cursor sharing mechanisms
- Control of execution via hints and profiles
- Diagnosis and resolution of complex query issues
Hands-On Tuning Scenarios
- Analysis of practical SQL challenges
- Step-by-step tuning drills
- Industry best practices and tuning checklists
Summary and Next Steps
Requirements
- Solid knowledge of Oracle SQL and PL/SQL
- Hands-on experience with Oracle Database in roles such as developer or DBA
- Foundational understanding of execution plans and indexing principles
Target Audience
- Oracle database developers
- Performance engineers
- Database administrators
21 Hours
Testimonials (1)
good explanation on each points and provide assignment for practices.
