Sale of my flagship training courses (and a free Exadata Internals seminar) ends on Friday, June 5

Oracle SQL Plan Stability

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