Re: Upgrade issues 11.2.0.3 to 11.2.0.4?

From: Syed Jaffar Hussain <sjaffarhussain_at_gmail.com>
Date: Tue, 31 Mar 2015 12:32:54 +0300
Message-ID: <CAD0-DggU0DsOBs3+NU6sK27WqhboPJ9Be9wOJ8uV7-JHuKyu2A_at_mail.gmail.com>



One of the customers faced performance (optimizer) issues after upgrading 11.2.0.1 to 11.2.0.4 to their customized HR module code in Oracle ERP. As a workaround, set the Setting optimizer_features_enable to 11.2.0.1 and everything back to normal.

You must be careful if you are going to change the COMPATIBLE parameter. Most importantly, test, test and test all functionality in non-production thoroughly.

On Mon, Mar 30, 2015 at 11:22 PM, Schauss, Peter (ESS) < peter.schauss_at_ngc.com> wrote:

> 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-l
>
>
>

-- 
Best Regards,

Syed Jaffar Hussain
Oracle ACE Director
<http://apex.oracle.com/pls/otn/f?p=19297:4:4640302666204919::NO:4:P4_ID:186>
Oracle Certified Master (10g)
<http://education.oracle.com/education/otn/shussain.html>
Lead-author Expert Oracle RAC 12c <http://www.apress.com/9781430250449>
Co-author Oracle 11gR1/R2 RAC Essentials <http://link.packtpub.com/yNZicz>
*Oracle Magazine DBA of year (2011)*
OCP 8i/9i/10g/11g DBA, RAC Certified Expert, ITIL V3 foundation certified
Charity : www.sajcharity.org
I blog at  : http://jaffardba.blogspot.com/
LinkedIn : http://www.linkedin.com/in/sjaffarhussain
Follow me on twitter : http://twitter.com/#!/sjaffarhussain
--------------------
"Winners don't do different things. They do things differently."

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Mar 31 2015 - 11:32:54 CEST

Original text of this message