Oracle SQL plan stability-related posts worth reading:
Posts by Oracle Optimizer group
- Maria Colgan - Manual SQL Plan Management and DBMS_SPM usage does not need Diagnostic/Tuning pack licenses
- SQL Plan Management (1/4) - Creating SQL Plan Baselines
- SQL Plan Management (2/4) – SPM Aware Optimizer
- SQL Plan Management (3/4) – Evolving SQL Plan Baselines
- SQL Plan Management (4/4) – User Interfaces and Other Features
- How do Adaptive Cursor Sharing and SQL Plan Management Interact?
SQL Plan Baselines
- Kerry Osborne – Oracle 11g SQL Plan Management, SQL Plan Baselines
- Jonathan Lewis – Manually creating “Fake Baselines“
- Kerry Osborne – Interaction Between Baselines and SQL Profiles
- Kerry Osborne – Why Isn’t Oracle Using My Outline/Profile/Baseline?
SQL Profiles
- Randolf Geist – Creating Stored Outlines and SQL Profiles from existing cursor
- Kerry Osborne – Creating Single Hint SQL Profiles
- Kerry Osborne – How to Attach a SQL Profile to a Different Statement
Finding and diagnosing problematic plans
- Kerry Osborne - Detect “unstable plans” with varying elapsed time per execution
- Kerry Osborne – Extracting a SQL with bind wars for rerunning the test case
