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.
- Introduction to Oracle Optimizer architecture.
- Key tuning concepts: cost, cardinality, and selectivity.
Understanding Execution Plans
- Methods for generating and interpreting execution plans.
- Comparison between EXPLAIN PLAN and DBMS_XPLAN.
- Identification of common performance pitfalls within plans.
Indexing Strategies
- Different index types and their implications for tuning.
- Creation and analysis of indexes to enhance performance.
- Application 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 capturing plans.
- Managing plan evolutions.
- Utilization of SQL plan directives.
Advanced SQL Tuning Techniques
- Bind peeking and adaptive cursor sharing.
- Using hints and profiles to control execution flow.
- Diagnosis and resolution of complex queries.
Hands-On Tuning Scenarios
- Analysis of real-world SQL problems.
- Step-by-step tuning exercises.
- Best practices and tuning checklists.
Summary and Next Steps
Requirements
- Proficiency in Oracle SQL and PL/SQL.
- Prior experience working with Oracle Database as a developer or DBA.
- Fundamental understanding of execution plans and indexing concepts.
Audience
- Oracle database developers.
- Performance engineers.
- Database administrators.
21 Hours
Testimonials (1)
good explanation on each points and provide assignment for practices.
