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
- Core tuning principles: cost, cardinality, and selectivity
Analyzing Execution Plans
- Generation and interpretation of execution plans
- Comparison of EXPLAIN PLAN and DBMS_XPLAN
- Identifying common performance issues within plans
Indexing Approaches
- Different index types and their impact on tuning
- Developing and evaluating indexes for optimal performance
- Implementation of invisible and function-based indexes
Oracle Tuning Utilities
- Automatic Workload Repository (AWR)
- Automatic Database Diagnostic Monitor (ADDM)
- SQL Tuning Advisor and SQL Access Advisor
Managing SQL Plans
- Plan baselines and the process of capturing plans
- Oversight of plan evolutions
- Application of SQL plan directives
Advanced SQL Tuning Methods
- Bind peeking and adaptive cursor sharing
- Controlling execution flow using hints and profiles
- Diagnosis and remediation of complex query issues
Practical Tuning Exercises
- Evaluation of real-world SQL challenges
- Guided, step-by-step tuning activities
- Best practices and comprehensive tuning checklists
Recap and Future Directions
Requirements
- Solid knowledge of Oracle SQL and PL/SQL
- Prior experience working with Oracle Database in a developer or DBA capacity
- Foundational understanding 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.
