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 and its objectives
- Architecture of the Oracle Optimiser
- Essential tuning concepts: cost, cardinality, and selectivity
Interpreting Execution Plans
- How to generate and read 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 assessing indexes for better performance
- Utilising 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
- Establishing plan baselines and capturing plans
- Managing plan evolution
- Applying SQL plan directives
Advanced SQL Tuning Techniques
- Addressing bind peeking and adaptive cursor sharing
- Controlling execution using hints and profiles
- Diagnosing and resolving complex query issues
Hands-On Tuning Scenarios
- Analysing real-world SQL challenges
- Step-by-step tuning practicals
- Industry best practices and tuning checklists
Summary and Next Steps
Requirements
- Solid grasp of Oracle SQL and PL/SQL
- Prior experience working with Oracle Database in a developer or DBA capacity
- Foundational knowledge of execution plans and indexing principles
Audience
- Oracle database developers
- Performance engineers
- Database administrators
Testimonials (1)
good explanation on each points and provide assignment for practices.
