SQL Plan Baselines

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

Christian Anognini:

An interesting observation on evolving baselines for delete statements

Kerry Osborne

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

Tim Hall

A description and walk-through on SQL Plan Baselines

Jason Arneil

Walking through evolving a plan baseline