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
- Overview of performance tuning objectives and scope.
- Architectural overview of the Oracle Optimizer.
- Core tuning metrics: cost, cardinality, and selectivity.
Interpreting Execution Plans
- Techniques for generating and reading execution plans.
- Comparative analysis of EXPLAIN PLAN versus DBMS_XPLAN.
- Recognizing common performance traps within execution plans.
Indexing Strategies
- Examination of index types and their impact on tuning.
- Best practices for creating and evaluating indexes for performance gains.
- Implementation of invisible and function-based indexes.
Oracle Tuning Tools
- Utilizing the Automatic Workload Repository (AWR).
- Applying the Automatic Database Diagnostic Monitor (ADDM).
- Leveraging the SQL Tuning Advisor and SQL Access Advisor.
SQL Plan Management
- Establishing plan baselines and capturing optimal plans.
- Managing the evolution of execution plans.
- Implementing SQL plan directives for consistent performance.
Advanced SQL Tuning Techniques
- Handling bind peeking and adaptive cursor sharing.
- Controlling execution flow through hints and profiles.
- Troubleshooting and optimizing complex SQL queries.
Hands-On Tuning Scenarios
- Analysis of actual SQL performance issues.
- Guided, step-by-step tuning practicals.
- Review of industry best practices and tuning checklists.
Summary and Next Steps
Requirements
- Solid proficiency in 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.
Target Audience
- Oracle database developers.
- Performance engineers.
- Database administrators.
Testimonials (1)
good explanation on each points and provide assignment for practices.
