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 #

Hi Mike,

Hope you are doing good.

I am really facing some serious performance issues on Oracle 11.2.0.4 with OS as Solaris SPARC 10. Export of 60GB full dump takes 1.5 day for example.

I have not installed any patches of Solaris and Oracle 11.2.0.4 from the beginning.

Do you suggest installing all latest patches for Solaris and Oracle? Please suggest.

Thanks,
Jauhari

Posted by guest on August 26, 2015 at 01:25 PM CEST #

Jauhari,

without knowing more details I can't give you a good advice.

My first assumption would always be:
You have LONG/LOB data in your tablespace(s) somewhere. That will slow down Data Pump. Furthermore make sure you always set EXCLUDE=STATISTICS as the export of stats will slow down the entire action.

Furthermore alter the PARALLEL parameter to have more workers do the job and use in addition a set of dumpfiles instead of only one single dump file.

Thanks
Mike

Posted by Mike on September 01, 2015 at 10:01 AM CEST #

Hi Mike,
I would need the following information as we are planning for Oracle Database Upgrade from 11.2.0.3 to 11.2.0.4 in our Exadata Environment.

1.Any known issues if you or your team faced while doing this upgrade.
2.Any do's and don't that we have to follow for the upgrade.

It would be a great help if you can tell us this information.

Thanks in Advance

Regards,
Dinesh

Posted by Dinesh on March 30, 2016 at 11:17 PM CEST #

Dinesh,

please see the Exadata upgrade notes in MOS.
They should cover almost everything you are looking for.

Thanks
Mike

Posted by Mike on March 31, 2016 at 02:03 PM CEST #

Hi All, I need help from you.

I am using Oracle database server 11.2.0.1 and recently i am facing some slowness in my application. If i restart the database then my application is working fine for 4/5/6hours then again getting slow.

(FYI, I am 11.2.0.1 for server and 11.2.0.4 for client and connecting the server through ODBC)

So can you please advice

Thanks

Posted by guest on April 22, 2016 at 08:26 AM CEST #

May I kindly ask you to:
(1) Upgrade to Oracle Database 11.2.0.4 or 12.1.0.2 as soon as possible?
(2) The apply the most recent Bundle Patch on top

Both installations can happen without interrupting your business as you'll install it into a new Oracle Home anyways.

Then you run the preupgrade check (either utlu112i.sql for 11.2 or preupgrd.sql for 12.1 upgrades - in any case take the most recent version of the script from MOS 884522.1).

Then you upgrade.

Check our big slide deck for gotchas and tips and tricks (Slides Download Center - Upgrade/migrate/consolidate to 12c).

Cheers
Mike

Posted by guest on April 28, 2016 at 02:53 PM CEST #

Hi Mike,

Thank you so much for your response and valuable suggestions/advice. Yes i can do that and FYI, I am very new to this upgrade process. So can i do EXPDP/IMPDP process instead of Upgrade process.

Can i do the below steps,
Step 1. Install 11.2.0.4 server database
Step 2. I can take backup from 11.2.0.1 (Using EXPDP or advice me which one will be good)
Step 3. Restore into 11.2.0.4 (Using IMPDP)

Are you agree this? If so, can you please advice me to where can i download 11.2.0.4 server edition (32 & 64 Bit, If you provide, it will be great).

Thank you so much for your time.

Thanks
Vetri

Posted by guest on April 29, 2016 at 09:42 AM CEST #

Post a Comment:
  • HTML Syntax: NOT allowed
About

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

Based in Germany. Interlink between customers/partners and the Upgrade Development. Running workshops between Arctic and Antartica. Assisting customers in their reference projects onsite and remotely. Connect via:

- -

Search

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