Here’s another of my little catalogues of articles – this one on SQL Plan Baselines.
Be a little careful as you read through these notes – there are various changes in internal mechanisms, storage, etc. as you go through different versions of Oracle, so check which version the author is writing about.
Maria Colgan of Oracle Corp.
1. Creating SQL Plan Baselines
2. SPM-aware Optimizer
3. Evolving SQL Plan Baselines
4. User Interfaces and other features
An interesting observation on evolving baselines for delete statements
1. Do SQL Plan Baselines use hints (pt.1)
2. Do SQL Plan Baselines use hints (pt. 2)
3. SQL Plan Management – SQL Plan Baselines
4. Why isn’t Oracle using my outline/ SQL profile / SQL Plan Baseline
5. Dynamic Sampling and profiles/baselines
6. Licence differences between profiles and baselines
A description and walk-through on SQL Plan Baselines
Walking through evolving a plan baseline