[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