Thanks to those of you who attended the Ask Tom Office Hours session on setting up the Oracle Optimizer for a Proof of Concept. Here's a PDF copy of the deck I used and it's available on slideshare too.
A video recording is available here.
Occasionally I want to get historical information on histogram
changes for a particular table. I have had a script in my back
pocket for a...
I am often asked, “How does Oracle choose which columns need a
histogram?” Also, “Why have I got a histogram on my primary...
Oracle Database 19c adds a new feature called automatic SQL
plan management. This post covers:
What is automatic SQL plan management and how...