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