Oracle SQL Tuning
Inside the Optimizer
Dive deep into how the Oracle database Optimizer works
* May 20 - 21, 2025 *
8:00-10:30AM Pacific
$375.00 USD (discounts for paid members)
Why should I attend this class?
Get in-depth knowledge
The Oracle Optimizer is a complex and powerful software. You need to go deep to understand how it works. Use this knowledge to find the root causes of SQL performance issues, and how to better use the features of the Optimizer when designing, using, or tuning SQL and database objects.
Learn how to find the answers
When should you collect object statistics? What is an adaptive SQL plan? Why did the Optimizer do that? Find the answers to these and more of your burning SQL tuning issues here.
Go beyond firefighting
We often focus on the quick fix and then return to the same problems again and again. Move away from this mindset and learn how to focus on the root cause of SQL performance issues and what can be done to find and fix them for good.
See how the Optimizer makes decisions
We will dive deep into how the Oracle database Optimizer works, covering advanced topics around statistics, tracing SQL statements, and adaptive SQL optimization. Here we will go deep into how the Optimizer makes decisions, and how you can directly influence them.
You will be able to:
Class Pricing:
Class Outline:
Session 1.
Session 2.
Details:
Class Hours: There are 4 hours of live, interactive hands-on class training divided into two 2-hour sessions, plus one hour of lab time.
Skill Level: You will need a basic understanding of SQL and Oracle database.
Class Structure: OraPub believes you learn more when you freely and actively engage during the training. This is why each session is full of live demonstrations, lots of Q&A time and lots of hands-on action! If you miss a session, you are free to attend that session when the class is offered again.
Watching Recorded Sessions: Each session is recorded and used to create a unique web page just for your class. The recordings can be streamed using any device, but not downloaded. You can re-watch the videos as many times as you wish. The videos and your unique class web page will be available for three years!
Class Requirements:
You will need:
Welcome OraPub Members!
Enter the member portal and be ready to be transformed in your Oracle DBA work.
© Copyrights by OraPub. All Rights Reserved.