New Oracle Optimizer, Partitioning and I/O Handling Deep Dives!

If you want to end the year by learning something practical and new, this is it!

I am running new special-focus deep dive seminars that address two complex Oracle Query Optimizer (CBO+stats) problem areas that keep popping up, even on modern Oracle 19c+ versions. The third one is about running I/O intensive Oracle databases, avoiding unnecessary bottlenecks and optimizing caching, writes & OS I/O subsystem.

This is heavily practical stuff, derived from real-life customer problems I’ve encountered in the last few years. I’ll show how all the involved components work (or not work) together and how I’ve troubleshooted, reasoned and fixed the underlying causes. There will be new troubleshooting scripts!

  1. Handling the Optimizer, Statistics and Workloads on Partitioned Tables in Oracle Databases
  2. Navigating Adaptive Behavior in Oracle SQL Optimizer and Plan Execution
  3. Running I/O-Intensive Oracle Databases On-Premises and in the Cloud

Training Schedule:

Between the training and Q&A sessions, you can put what you’ve learned into use and email me your questions. I’ll either answer via email or explain them with a demo at the Q&A time.

The course topics and details are listed in the Tanel_Poder_Performance_Seminars_2025.pdf file.

If you have any questions, drop me an email directly at training@poderc.com.

Sign up here:


Special-Focus Deep Dives Price USD Attend
Handling Optimizer, Workloads, Stats with Partitioning (5-6 Nov) $792
Running I/O-Intensive Databases (on-prem & cloud) (18-19 Nov) $792
Navigating Adaptive Behavior in Oracle SQL Optimizer (9-10 Dec) $792
Two-Course Discounted Bundle (15%) $1,346
Three-Course Bundle Discount (25%) $1,782

Follow-up Q&A Session Schedule:

The 2-hour follow-up discussion meetings take place at 12:00pm-2:00pm US EST on the listed days:

I will send you calendar invites with Zoom links for your sessions.


In addition to the special-focus deep dives above, you can still buy for my full-length general troubleshooting & optimization video training courses, covering a much wider area of Oracle, Linux functionality and the problem space.

Full-Week Video Training Courses (Self-Paced)

I currently offer three flagship video-training courses and an occasional advanced special-focus seminar:

If you want to know more about my performance & troubleshooting work over the last 30 years, you can read more about my journey here.

Get more details and view course outlines in my learning platform:

Read more about the new training structure and format below.

Training Format

Tanel’s training courses are now delivered in a new format, designed for self-paced learning from training videos. Tanel’s courses are different from other typical offerings out there, as they’re fully based on his long-time enterprise consulting experience of what actually works in real life, when solving complex problems across a variety of different applications, database systems and platforms out there.

The main troubleshooting & optimization techniques introduced in these classes are designed to be safely usable in mission-critical enterprise production environments. Tanel uses exactly the same methods and tools when helping his customers all around the world.

From Tanel’s courses, you will learn not only some theory of how the Oracle Database engine (or Linux) is supposed to work. Thanks to spending over half of the course time on demos of solving actual problems, you will also learn how these complex systems really work under constant load, including advanced examples of troubleshooting bugs and other unexpected behavior.

What you will get:

View course outlines in Tanel’s learning platform here: