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 strategic goals.
- A look at the architecture of the Oracle Optimizer.
- Core tuning concepts, including cost analysis, cardinality, and selectivity.
Interpreting Execution Plans
- Techniques for generating and deciphering execution plans.
- Comparing EXPLAIN PLAN with DBMS_XPLAN.
- Identifying common performance issues within execution plans.
Indexing Strategies
- Examining various index types and their impact on tuning.
- Creating and evaluating indexes to enhance performance.
- Implementing invisible and function-based indexes.
Oracle Tuning Utilities
- Utilizing the Automatic Workload Repository (AWR).
- Leveraging the Automatic Database Diagnostic Monitor (ADDM).
- Applying the SQL Tuning Advisor and SQL Access Advisor.
SQL Plan Management
- Managing plan baselines and capturing optimal plans.
- Handling plan evolution processes.
- Employing SQL plan directives.
Advanced SQL Tuning Techniques
- Addressing bind peeking and adaptive cursor sharing.
- Controlling execution flow through hints and profiles.
- Diagnosing and resolving complex query challenges.
Hands-On Tuning Scenarios
- Analyzing SQL issues from real-world environments.
- Executing detailed, step-by-step tuning exercises.
- Adopting best practices and utilizing tuning checklists.
Summary and Next Steps
Requirements
- A solid grasp of Oracle SQL and PL/SQL fundamentals.
- Practical experience with Oracle Database, either as a developer or a database administrator (DBA).
- Foundational knowledge of execution plans and indexing principles.
Target Audience
- Oracle database developers.
- Performance engineers.
- Database administrators.
21 Hours
Testimonials (1)
good explanation on each points and provide assignment for practices.
