SQL Plan Management Choices

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.

Advertisements

3 Responses to SQL Plan Management Choices

  1. hourim says:

    Very nice job Dom.

    Thanks for this

    Mohamed

  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 Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: