RE: Flushing Bad Plan - No Longer in Shared Pool

From: Deas, Scott <Scott.Deas_at_lfg.com>
Date: Wed, 18 Nov 2015 20:46:08 +0000
Message-ID: <C1FB7BA65B13C542B2CB1CE5DB8F74AF1EBE1670_at_NC2PWEX501.us.ad.lfg.com>



Thanks Wolfgang, we're going to attempt this approach now.

Thanks,
Scott

From: Wolfgang Breitling [mailto:breitliw_at_centrexcc.com] Sent: Wednesday, November 18, 2015 3:42 PM To: Deas, Scott
Cc: oracle-l_at_freelists.org
Subject: Re: Flushing Bad Plan - No Longer in Shared Pool

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?

Notice of Confidentiality: **This E-mail and any of its attachments may contain Lincoln National Corporation proprietary information, which is privileged, confidential, or subject to copyright belonging to the Lincoln National Corporation family of companies. This E-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this E-mail, you are hereby notified that any dissemination, distribution, copying, or action taken in relation to the contents of and attachments to this E-mail is strictly prohibited and may be unlawful. If you have received this E-mail in error, please notify the sender immediately and permanently delete the original and any copy of this E-mail and any printout. Thank You.**

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Nov 18 2015 - 21:46:08 CET

Original text of this message