SQL Plan Management is the elegant solution 11g offers for achieving plan stability on the one hand, and on the other offer you a controlled manner for evolving your execution plans for achieving better performance. The main vehicle for achieving plan stability in 11g is the SQL Plan Baseline, which essentially comprises a set of accepted execution plans.
In this post I have gathered the MUST-READ material for SQL Plan Management:
In this post I have gathered the MUST-READ material for SQL Plan Management:
- Maria Colgan's 4-part blog series on SQL Plan Management
- part 1 - Creating SQL Plan Baselines
- part 2 - SPM Aware Optimizer
- part 3 - Evolving SQL Plan Baselines
- part 4 - User Interfaces and Other Features
- SQL Plan Management Oracle white paper
- Carlos Sierras' post on how to create a baseline for an SQL with an accepted plan based on a modified SQL (e.g., a hinted version of the original SQL). The baseline (an thus the corresponding accepted plan) will be applied to the original SQL and not to the modified one.
- All relevant posts from the Oracle Optimizer Blog
- And of course the Oracle Performance Tuning Guide's corresponding chapter.
Enjoy!
OL
