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.
- An introduction to the Oracle Optimizer architecture.
- Core tuning concepts: cost, cardinality, and selectivity.
Interpreting Execution Plans
- Generating and analyzing execution plans.
- Comparing EXPLAIN PLAN with DBMS_XPLAN.
- Identifying common performance pitfalls within plans.
Indexing Strategies
- Different index types and their impact on tuning.
- Creating and assessing indexes for enhanced performance.
- Leveraging invisible and function-based indexes.
Oracle Tuning Tools
- The Automatic Workload Repository (AWR).
- The Automatic Database Diagnostic Monitor (ADDM).
- The SQL Tuning Advisor and SQL Access Advisor.
SQL Plan Management
- Managing plan baselines and capturing execution plans.
- Handling plan evolution processes.
- Applying SQL plan directives.
Advanced SQL Tuning Techniques
- Bind peeking and adaptive cursor sharing.
- Controlling execution through hints and profiles.
- Diagnosing and optimizing complex queries.
Hands-On Tuning Scenarios
- Analyzing SQL issues from real-world contexts.
- Step-by-step practical tuning exercises.
- Industry best practices and tuning checklists.
Summary and Next Steps
Requirements
- A 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.
Target Audience
- Oracle database developers.
- Performance engineers.
- Database administrators.
Testimonials (1)
good explanation on each points and provide assignment for practices.
