Re: Flushing Bad Plan - No Longer in Shared Pool

  • From: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
  • To: Scott.Deas@xxxxxxx
  • Date: Wed, 18 Nov 2015 13:42:10 -0700

Yes. Just create a baseline from it and mark it as not enabled. Baselines can
be used both ways: to mark desirable plans as enabled ( and accepted and fixed
) as well as mark non-desirable plans as not enabled ( and not fixed ).


Is there a way to completely eliminate or invalidate a past plan from being
considered by the optimizer again?

Other related posts: