Re: Completely insane execution plan with 11.2.0.3 but not with 11.2.0.2
Date: Fri, 27 Jul 2012 13:08:46 -0400
Message-ID: <CAGzKQQfzrPcYWhZXH2Zh-ByCMkwCGKWZOf9WS1_KkA1q-8FT=A_at_mail.gmail.com>
Thomas,
If you have an SR, just upload to that SR and send me SR number.
Thx -- Carlos
On Fri, Jul 27, 2012 at 10:04 AM, Thomas Kellerer < thomas.kellerer_at_mgm-tp.com> wrote:
> Carlos Sierra, 24.07.2012 13:12:
>
>> You may want to install SQLT (215187.1) in both environments and use
>> XTRACT method. Then send me output for diagnostics. I would use SQLT
>> XPLORE in your SQLT, which basically helps to narrow the optimizer
>> change between 11.2.0.2 and 11.2.0.3 which affects your plan so
>> badly.
>>
>>
> I have extracted two SQLT (XTRACT) reports now.
> One with OFE = 11.2.0.2 and one with OFE = 11.2.0.3
>
> The both show the differences in the plans.
>
> The zip files are both well over 100MB each. How can I let you have those
> files?
>
> They do contain some sensible (customer's) information, so I can't really
> put them somewhere "public".
>
>
> Regards
> Thomas
>
>
>
>
>
-- Cheers -- Carlos Sierra http://carlos-sierra.net/ -- http://www.freelists.org/webpage/oracle-lReceived on Fri Jul 27 2012 - 12:08:46 CDT