Video Tutorials

Here’s a list, some with videos, some just a slide deck, of presentations I have given over the last few years. More will be added as time passes.

Why has my plan changed? Top 7 Plan Stability Pitfalls from ACES@Home Webinar May 2020
Oracle Database Statistics – The Easy Way from UKOUG Webinar 2019
Database Statistics – When It’s Harder from UKOUG Techfest19 – December 2019. Information about Stats Gathering for partitions, synopses, tracing and other trickier situations
Histograms are Evil like Chocolate is Evil How do Histograms work in Oracle 12C, what is good and bad about them.
Oracle Execution Plan Changes Looking at how the plan stability aspects of the optimizer works
Using JSON on Oracle How to store and efficiantly access JSON in an Oracle 12C or 12C database, and the performance implications of using JSON
Plan Stability Pitfalls from Riga Dev Days 2018