SQL Plan Management Choices

August 11, 2015 3 Comments

My thoughts on SQL plan management decision points: SPM SQL Patches are also available, primarily to avoid a specific problem not to enforce a particular plan, and are not covered in the above flowchart.

Filed under 11gR2, 12c, oracle, sql, sql baselines, sql plan management, sql profile

3 Responses to SQL Plan Management Choices

  1. hourim says:
    August 11, 2015 at 1:22 pm

    Very nice job Dom.

    Thanks for this

    Mohamed

    Reply

  2. Pingback: Adaptive Cursor Sharing triggering mechanism | Mohamed Houri’s Oracle Notes

  3. Pingback: Oracle Optimizer and SPM plan interaction | Mohamed Houri’s Oracle Notes

Leave a comment