OAUG/Collaborate Recap: Best Practices for E-Business Suite Performance Tuning

[June 24, 2011 Update: Added link to PDF version]

We have an Applications Performance Group whose raison-d'etre is to ensure that the E-Business Suite runs at peak performance in all circumstances.  This team has helped tune the E-Business Suite environments of world's largest companies to handle staggering amounts of transactional volume in multi-terabyte databases.  This group also publishes our official Oracle Apps benchmarks, white papers, and performance metrics.

Isam Alyousfi and Lester Gutierrez are key members of our Applications Performance Group.  They recently presented their popular session covering performance tuning tips for all layers of the E-Business Suite at OAUG/Collaborate earlier this year.  It's available for download here:

EBS Architecture diagram from a performance perspective

This sprawling presentation covers:

  • Performance-oriented architectural overview of the E-Business Suite, with drilldowns to key techstack modules
  • Methodology for approaching performance issues, including isolation of performance problems within a particular area (e.g. database vs. application tier)
  • Comprehensive list of performance-related data to gather, including SQL tuning, PL/SQL Tuning, Reports Tracing, Database tuning, Forms tuning, Middle tier tuning
  • Methods for conducting root-cause analysis for performance issues
  • Methods for selecting the right diagnostics for particular classes of performance issues
  • Tuning the Applications tier:  Forms, OC4J/JVM, CPU and response time issues, garbage collection tuning, handling OutOfMemoryErrors and memory leaks, client process CPU drains
  • Tuning the Concurrent Manager: cache size, dedicated concurrent managers, FND table purging, workload management tips, transaction managers for synchronous online processing
  • Tuning the Client and Network: minimizing browser footprints, network routing issues, packet loss
  • Tuning the Database: mandatory init.ora settings, required performance patches, use of key database features like Auto Memory Management, conversion to the Oracle Applications Tablespace Model (OATM), I/O optimization, statistics gathering, establishing baselines for different workloads, using SQL Performance Analyzer and SQL Plan Management, AWR reviews, DB Console, TKPROF, 11g performance-related enhancements
  • Tuning EBS products: Release Update Pack recommendations, performance-related product patches, Workflow best practices, purging and archiving, runtime performance testing tips

This presentation is chock full of tips, pointers, and hard-won knowledge.  It represents the distillation of countless performance-related Service Requests and customer escalations.  If you're grappling with performance issues in your environment, or simply trying to squeeze more performance out of existing hardware, I'd strongly recommend downloading this presentation.

Related Articles


On the blog home page and this page:

the link for "Debugging General Performance Issues with Oracle Apps"
isn't correct.

Posted by Chris on June 17, 2011 at 01:32 AM PDT #

Very useful presentation. I recommend this PPT must be used by all Oracle APPS DBA.

Posted by guest on June 19, 2011 at 08:51 PM PDT #

Hi Steven,

Whenever I download and open the ppt http://www.oracle.com/technetwork/apps-tech/collaborate-2011-tuning-ebusiness-416502.ppt in Powerpoint 2010 it says that ppt is corrupted and repairs it which makes some pages blank.

- Vikram

Posted by Vikram Das on June 20, 2011 at 08:19 AM PDT #

Thanks for this useful document.
We still have problems with java.lang.outofmemory errors with XML reports. It seems this is because of the 2Gb limitation of 32-bit jvm. Are there any options/plans to use 64-bit JVM's?

Posted by Pieter on June 20, 2011 at 08:43 PM PDT #


The link seems to work fine. Please retry it; you might have experienced a caching issue of some sort.


Posted by Steven Chan on June 21, 2011 at 04:12 AM PDT #

Hi, Vikram,

I'm sorry that you're experiencing trouble with the download. It seems to work fine for me (although I use a relatively ancient copy of PowerPoint 2003). I'd recommend retrying your download.


Posted by Steven Chan on June 21, 2011 at 04:14 AM PDT #


Sorry to hear you're having memory-related trouble. Have you logged Service Requests for those issues?

We are considering 64-bit JVMs for a future E-Business Suite release. As always, I can't provide specific timelines for this. I'll post more details here once they become publicly available.


Posted by Steven Chan on June 21, 2011 at 04:16 AM PDT #

Hi Steven, I also have the same problem Peter reported and with the same version of PowerPoint. I re-downloaded a few times, to no avail. Any chance you could re-post the presentation as a PDF? It really is very useful.

Posted by Ara on June 21, 2011 at 07:43 AM PDT #

Steve, can you upload a PDF version of the presentation? Like others, I have problems opening the PPT in newer versions of PowerPoint (mine is 2007). The end result is that some pages are blank, which makes the presentation only partially useful.

Posted by Mark on June 22, 2011 at 07:22 AM PDT #

Mark, Ara, Vikram, others,

Sorry you had trouble with this presentation. I've uploaded a PDF version; see the article above for the link.


Posted by Steven Chan on June 24, 2011 at 06:52 AM PDT #

I saw that. Thanks!

Posted by Ara on July 08, 2011 at 03:21 AM PDT #

Post a Comment:
  • HTML Syntax: NOT allowed


« July 2016