Re: Upgrade issues 11.2.0.3 to 11.2.0.4?
- From: Syed Jaffar Hussain <sjaffarhussain@xxxxxxxxx>
- To: peter.schauss@xxxxxxx
- Date: Tue, 31 Mar 2015 12:32:54 +0300
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@xxxxxxx> 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
> --
> //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."
Other related posts:
