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 goals
- Architecture of the Oracle Optimizer explained
- Core tuning metrics: cost, cardinality, and selectivity
Interpreting Execution Plans
- Methods for generating and analyzing execution plans
- Comparison between EXPLAIN PLAN and DBMS_XPLAN
- Identification of common performance issues within plans
Indexing Strategies
- Different index types and their impact on tuning
- Creating and evaluating indexes for maximum performance
- Application of invisible and function-based indexes
Oracle Diagnostic Tools
- Leveraging the Automatic Workload Repository (AWR)
- Using the Automatic Database Diagnostic Monitor (ADDM)
- Utilizing the SQL Tuning Advisor and SQL Access Advisor
SQL Plan Management
- Establishing plan baselines and capturing execution plans
- Overseeing the evolution of SQL plans
- Implementing SQL plan directives
Advanced SQL Tuning Techniques
- Addressing bind peeking and adaptive cursor sharing
- Controlling execution via hints and profiles
- Diagnosing and optimizing complex query structures
Practical Tuning Scenarios
- Examination of real-world SQL performance challenges
- Progressive, step-by-step tuning practicals
- Review of best practices and standard tuning checklists
Summary and Future Directions
Requirements
- Solid proficiency in Oracle SQL and PL/SQL.
- Practical experience interacting with Oracle Database in either a development or DBA capacity.
- Fundamental knowledge of execution plan interpretation and indexing principles.
Target Audience
- Oracle database developers.
- Performance engineers.
- Database administrators.
Testimonials (1)
good explanation on each points and provide assignment for practices.
