Re: Really strange performance issue

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Thu, 30 Oct 2014 10:03:37 -0500
Message-Id: <3DFC210B-1A4A-4CF8-87EF-A59981F10D58_at_gmail.com>

And we have a winner. The actual plan must have changed, even though when I just ran the explain command it did not. I turned off _optimizer_use_feedback and that fixes it. The question is why?

Sent from my iPad

> On Oct 30, 2014, at 9:49 AM, Mauro Pagano <mauro.pagano_at_gmail.com> wrote:
>
> Does the execution plan change between first and second execution?
> If no the ignore the rest of my message but if yes then an educated guess (since we have no other info available) would be "cardinality feedback", you can test it setting "optimizer_use_feedback" = false
>

>> On Thu, Oct 30, 2014 at 10:42 AM, Howard Latham <howard.latham_at_gmail.com> wrote:
>> Any chance of seeing the Query please?
>> --
>> http://www.freelists.org/webpage/oracle-l

>
>
>
> --
> http://about.me/mauro.pagano

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Oct 30 2014 - 16:03:37 CET