Re: Upgrade issues 11.2.0.3 to 11.2.0.4?
From: Stefan Koehler <contact_at_soocs.de>
Date: Tue, 31 Mar 2015 14:23:56 +0200 (CEST)
Message-ID: <1779471531.16113.1427804636173.JavaMail.open-xchange_at_app01.ox.hosteurope.de>
Hi Peter,
just in addition to what the other guys said. Reverting parameter optimizer_features_enable to the previous version does not necessarily result in the previously generated execution plan. Any CBO fix or feature that is not under fix_control will not be reverted.
Date: Tue, 31 Mar 2015 14:23:56 +0200 (CEST)
Message-ID: <1779471531.16113.1427804636173.JavaMail.open-xchange_at_app01.ox.hosteurope.de>
Hi Peter,
just in addition to what the other guys said. Reverting parameter optimizer_features_enable to the previous version does not necessarily result in the previously generated execution plan. Any CBO fix or feature that is not under fix_control will not be reverted.
We already discussed this on Oracle-L here: https://www.freelists.org/post/oracle-l/Looking-for-notes-examples-where-OFE-doesnt-help,2
Best Regards
Stefan Koehler
Freelance Oracle performance consultant and researcher
Homepage: http://www.soocs.de
Twitter: _at_OracleSK
> "Schauss, Peter (ESS)" <peter.schauss_at_ngc.com> hat am 30. März 2015 um 22:22 geschrieben:
>
>
> We are getting ready to migrate some databases from 11.2.0.3 (Windows 2003) to 11.2.0.4 (Linux - Redhat 6.6). Are there any major changes in the
> optimizer that we should be concerned about?
>
> Thanks,
> Peter
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Mar 31 2015 - 14:23:56 CEST