Re: Really strange performance issue
- From: Andrew Kerber <andrew.kerber@xxxxxxxxx>
- To: Mauro Pagano <mauro.pagano@xxxxxxxxx>
- Date: Thu, 30 Oct 2014 10:03:37 -0500
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@xxxxxxxxx> 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@xxxxxxxxx>
>> wrote:
>> Any chance of seeing the Query please?
>> --
>> //www.freelists.org/webpage/oracle-l
>
>
>
> --
> http://about.me/mauro.pagano
Other related posts:
