Maintaining Your EBS Environment for Maximum Performance

I think that all E-Business Suite DBAs know that they need to apply a number of interoperability patches when upgrading from one database release to another.  These are documented in our Interoperability Upgrade Notes for a given EBS + database combination.  For example, if you're upgrading Oracle E-Business Suite Release 12 to the latest 11gR2 11.2.0.2 database, you'd apply the patches listed here:
However, I don't think it's as widely-known that there are two other classes of patches that you might need to apply.  These are documented in the following two Notes:
  1. Oracle E-Business Suite Recommended Performance Patches (Note 244040.1)
  2. Database Patch Set Update Overlay Patches Required for Use with PSUs and Oracle E-Business Suite (Note 1147107.1)

Performance benchmark graph for EBS 12 1 2 cpu_load.png


What are E-Business Suite "recommended performance patches"?

Oracle E-Business Suite Recommended Performance Patches (Note 244040.1) is written and maintained by our Applications Performance team.  I've covered this team's responsibilities previously, but to recap: this team is dedicated to optimizing the performance of the E-Business Suite.  They perform all of our E-Business Suite benchmarks and high-volume scalability testing, and they work intensively with our largest E-Business Suite customers in fine-tuning E-Business Suite configurations. 

They've summarized all of their hard-won expertise about performance-related patches in a single document.  A major part of this document covers database patches, but that's not all.  It also covers performance-related patches for:
  • Client tools
  • Applications Technology products and components
  • Financials products
  • Manufacturing and Supply Chain products
  • Human Resources products
  • Sales & Marketing products
This should be your first stop after upgrading your database or if you're trying to nail down a troublesome database performance-related issue.  I consider this mandatory reading for all E-Business Suite DBAs.

Do you want to apply database Patch Set Updates?

Our Server Technologies division began releasing quarterly database Patch Set Updates (PSU) in July 2009.   Patch Set Updates include:
  • Field-tested fixes for critical technical issues that may affect a large number of customers
  • Critical Patch Update fixes
Database Patch Set Updates are optional for E-Business Suite users.  If you choose to use them, database Patch Set Updates may safely be applied to Oracle E-Business Suite Release 11i and 12 environments.  Patch Set Updates are fully compatible and supported for use with the E-Business Suite.  Depending upon the database version and Oracle E-Business Suite release, one or more overlay patches may be required to address conflicts with a specific Oracle Database Patch Set Update.

Database Patch Set Update Overlay Patches Required for Use with PSUs and Oracle E-Business Suite (Note 1147107.1) summarizes the latest overlay patches required when applying Database Patch Set Updates to Oracle E-Business Suite environments running on the 10gR2, 11gR1, and 11gR2 databases.  If you use PSUs with your EBS database, you should review this Note on a regular basis.

Related Articles

Comments:

As always, thanks for the information Steven. I had no idea there existed such a thing as a database patch set update overlay patch (how long have they existed?) until I read your article.

Posted by Kevin Kempf on December 06, 2010 at 11:52 PM PST #

Hi, Kevin,

You're welcome. These sprung into existence shortly after the database PSUs. I'd be interested in hearing about your experiences with these; drop me a line if you have time.

BTW, I enjoyed your recent Discoverer upgrade article.

Regards,
Steven

Posted by Steven Chan on December 07, 2010 at 01:00 AM PST #

Currently we are running EBS R12.1.3 on X86_64 and oracle version 11.1.0.7.

problem we have are continue get 'temp tablespace out of extent". Temporary tablespace we setup is 32 GB.

if we run analyze statistics normally problem can fix. It cause us need run analyze statistics two to three times a day.

Any idela for this?

Posted by duffy on February 03, 2011 at 03:25 AM PST #

Duffy,

I'm sorry to hear that you've encountered an issue with this.

We can provide general conceptual guidance here, but I'm afraid that this blog isn't the best place to get technical support for specific issues like the one that you're working through.

Your best bet would be to log a formal Service Request via My Oracle Support (formerly Metalink) to get one of our specialists engaged.

Please feel free to forward your Service Request number to me if it gets stuck in the support process for some reason.

Regards,
Steven

Posted by Steven Chan on February 07, 2011 at 01:11 AM PST #

Post a Comment:
  • HTML Syntax: NOT allowed
About

Search

Categories
Archives
« April 2014
SunMonTueWedThuFriSat
  
1
4
5
6
7
8
9
10
11
12
13
14
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today