Re: Completely insane execution plan with 11.2.0.3 but not with 11.2.0.2
From: Thomas Kellerer <thomas.kellerer_at_mgm-tp.com>
Date: Fri, 27 Jul 2012 16:04:20 +0200
Message-ID: <50129FE4.4090300_at_mgm-tp.com>
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.
>
Date: Fri, 27 Jul 2012 16:04:20 +0200
Message-ID: <50129FE4.4090300_at_mgm-tp.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Jul 27 2012 - 09:04:20 CDT