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: Tue, 24 Jul 2012 16:21:05 +0200
Message-ID: <500EAF51.6000302_at_mgm-tp.com>
Greg Rahn, 24.07.2012 08:05:
> 1) export statistics from 11.2.0.2 and import them to the 11.2.0.3 db
> 2) set init.ora parameters identical
> 3) validate that the issue still exists
Date: Tue, 24 Jul 2012 16:21:05 +0200
Message-ID: <500EAF51.6000302_at_mgm-tp.com>
Greg Rahn, 24.07.2012 08:05:
> 1) export statistics from 11.2.0.2 and import them to the 11.2.0.3 db
> 2) set init.ora parameters identical
> 3) validate that the issue still exists
OK, I did this now (although I cannot make init.ora completely identical) and the problem still persists.
(Actually in the meantime the "bad" plan got even worse, Oracle now estimates a total of 15E bytes - guess they really want to sell Exadata ;) )
Regards
Thomas
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jul 24 2012 - 09:21:05 CDT