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:
- Understand what an SQL execution plan is
- Understand how the Optimizer builds execution plans
- See what object statistics are, and what they represent
- Know what heuristics are, and how they are used
- Learn what system statistics are, and how they are used
- See how to trace a SQL statement and read trace information
- Learn about Oracle’s adaptive Optimizer features
- Learn what a SQL Patch is, and why you would create one
Class Pricing:
- $375 USD for Free members
- $300 USD for Essential & Advantage members (ask for your coupon code)
- FREE for Prime members (just ask to be registered)
Class Outline:
Session 1.
- Oracle Optimizer basics
- Oracle Optimizer advanced
- Object and System statistics
- 30 minute lab
Session 2.
- Review
- Tracing SQL statements
- Adaptive Optimizer features
- Oracle SQL Patch
- Q & A
- 30 minute lab
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:
- An up-to-date modern browser such as Google Chrome, Microsoft Edge, Mozilla Firefox or Apple's Safari.
- The ability to connect to the online training over the internet, hosted by Zoom. You do not need a microphone.
Welcome OraPub Members!
Enter the member portal and be ready to be transformed in your Oracle DBA work.
© Copyrights by OraPub. All Rights Reserved.