Avoid Poor Performance and Wrong Results in 11.2.0.4

One of the best notes in MOS got refreshed last night for Oracle Database 11.2.0.4. It has not only information about performance bugs but also about the worst and meanest category of issues, wrong query result bugs. Those are the ones I call the "sleeping beauties" as you as a DBA usually won't recognize them. It is recognized at the application level when the result of a report is incorrect or instead of 4 rows just 3 rows get delivered in the output. Therefore you should be highly aware of those and add this note to your bookmarks.

MOS Note 1645862.1Things to Consider Before Upgrading to 11.2.0.4 to Avoid Poor Performance or Wrong Results

And in case you don't want to move to Oracle 11.2.0.4 but searching for information and known issues in Oracle 11.2.0.3 or Oracle 11.2.0.2 then please find the corresponding documents:

  • MOS Note: 1320966.1 Things to Consider Before Upgrading to 11.2.0.2.x to Avoid Poor Performance or Wrong Results
  • MOS Note: 1392633.1 Things to Consider Before Upgrading to 11.2.0.3 to Avoid Poor Performance or Wrong Results
-Mike
Comments:

Oracle 11.2.0.4 RAC Installation on OL7/RHEL 7.

Can you please tell me did u faced any issues or any changes after or during the installation. Did you people find any performance issues/bugs.

We have an new build project, So just want to know can i recommended the 11.2.0.4 on RHEL 7(because in future i may need to upgrade db to 12C).

Regards,

Preethi

Posted by preethi on March 03, 2015 at 11:11 AM CET #

Preethi,

right now all the customers we are working with are going to 12.1.0.2 - 11.2.0.4 is really LONG TIME AGO for us ;-)

You may check the slides for 11g (scroll down in the Slide Download Center to your right until the bottom - there's the unchanged 11g deck with issues highlighted).

Thanks
Mike

Posted by Mike on March 04, 2015 at 03:29 PM CET #

Hello Mike,
Good day.

We are moving to a virtual platform from 11.2.0.2 to 11.2.0.4 since the support for 11.2.0.2 has ended.
Will you be kind enough to let us know what changes this release brings to the table.
We are supposed to be on N-1 patch level framework and hence the lower version.

Thanks,
Manish

Posted by guest on June 13, 2015 at 11:49 AM CEST #

Manish,

sorry but I'll be unable to provide you all the changes involved with 11.2.0.4. You may please check the Upgrade Companion on MOS (see Behaviour Changes section) and the 11.2.0.4 Upgrade Guide as it contains a good number of changes to views etc.

Cheers
Mike

Posted by Mike on June 15, 2015 at 10:40 AM CEST #

Post a Comment:
  • HTML Syntax: NOT allowed
About

Mike Dietrich - Oracle Mike Dietrich
Master Product Manager - Database Upgrade & Migrations - Oracle Corp

Based near Munich/Germany and spending plenty of time in airplanes to run either upgrade workshops or work onsite or remotely with reference customers. Acting as interlink between customers/partners and the Upgrade Development.

Follow me on TWITTER

Contact me via LinkedIn or XING

Search

Archives
« August 2015
SunMonTueWedThuFriSat
      
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
     
Today
Oracle related Tech Blogs
Slides Download Center
Visitors since 17-OCT-2011
White Paper and Docs
Workshops
Viewlets and Videos
This week on my Rega/iPod/CD
Workshop Map
Upgrade Reference Papers