Master Class in Apps 11i Performance Tuning

Ahmed Alomari is one of Oracle's foremost experts in optimizing performance for the E-Business Suite.  His OpenWorld sessions are always filled with DBAs looking for practical tips on getting more out of their existing hardware, and this year's session was packed with more practical pointers than ever before. 

If you're looking for a master-class in Apps performance tuning, it doesn't get better than this.  Better yet, it's all contained in a single free download.

Gather Schema Statistics Screenshot:

In his presentation, Ahmed covers:

  • Optimization of Forms and Reports
    • Via socket mode, Forms Dead Client detection, and the latest performance-related Forms patches
    • Costs of using Cancel Query
    • Things that your end-users can do to improve performance
    • Tracing Forms performance via SQL and FRD tracing 
    • Optimization of Report via SQL tracing, or by enabling the built-in Reports Trace feature

  • Optimization of Concurrent Manager:
    • Using specialization rules and work shifts to bind jobs to specific time windows
    • Conflict Resolution Manager sleep time guidelines for parallel workers
    • Tips for using Transaction Managers for Inventory Transactions and other synchronous online processing
    • Pipes be gone!  Avoiding transaction manager instances per database instance for RAC
    • Tracing and debug options at the program and request level
  • Optimization of the Application Tier
    • Tuning Apache processes and clients via httpds.conf settings
    • Caching of non-HTML resources such as images, style sheets, and Java scripts via httpd.conf or apps.conf settings
    • Configuring dedicated mod_plsql listeners
    • Apache Jserv / JVM logging and auto load-balancing
    • Tuning Apache Hotspot and garbage collection settings, and interpreting GC output to tune JVM heaps
    • Reducing Java memory and connection leaks
    • Tracking JDBC connections
    • Performance benchmarks after upgrading to JDK 5.0:  ~ 15%!
    • New JDK 5.0 performance management tools, including Jconsole, jps, jstat, visualgc
    • Optimizing Java Server Pages via precompilation
    • Tuning Portal-related settings
    • Discoverer 10g performance-related options
  • Tuning Network performance
    • Testing latency with via ping and optimal packet sizes
    • Performance benchmarks for using Web Cache for compression
  • Tuning Database tier performance
    • Optimal buffer cache and shared pool settings
    • Use of asynchronous I/O, Quick I/O, and locally managed temp files
    • Use of Stats Pack and AWR to take performance snapshots, and things to look for in those snapshots
    • Database performance metrics to monitor
    • Allocating CPU resources via Database Resource Manager
    • Tips for minimizing the impact of gathering statistics, and how to interpret the results
    • Benefits of the new OA Tablespace Model, and before-and-after benchmark comparisons (e.g. a 1.4 TB database shrunk to 850 GB!)

  • And much, much more...
Even if you're not having performance issues now, this is worth a look.  If you are having performance issues, reviewing this presentation should be your top priority today:


i would like to add the following link is a voice interview with Mr. ahmed and its about prefomance tuning nice one try to hear it.

fadi hasweh

Posted by Fadi Hasweh on December 06, 2006 at 11:31 PM PST #

I missed that one. This is excellent. Thanks!

Posted by Kevin Krause on December 07, 2006 at 01:33 AM PST #

I concur about Ahmed. I remember Ahmed well from some very high-end joint Oracle/Sequent accounts way back when!

Posted by Kevin Closson on December 08, 2006 at 06:07 AM PST #

Good suggestion, Fadi.  I've added a link to that AppsCast to the article.Regards,Steven 

Posted by Steven Chan on December 08, 2006 at 08:01 AM PST #

i can not find patch 4122271 mentioned in 5 page of this presentation.
"Socket" mode slower for me than "http"-mode even in the intranet.

Posted by Lev on December 08, 2006 at 09:42 PM PST #

Lev,It appears that this patch hasn't been released yet.  I'll passed along a request for an estimated release date to the development team that owns it.  Regards,Steven 

Posted by Steven Chan on December 11, 2006 at 02:23 AM PST #

Lev,It turns out that patch 4122271 isn't released separately, but it is included directly in the 11.5.10 Consolidated Update #2.  See Metalink Note 3163661.1 for links to CU#2, if you haven't already installed that in your environment.Regards,Steven 

Posted by Steven Chan on December 11, 2006 at 10:59 AM PST #

An addendum from Ahmed himself:<snip>... we always recommend RUP4 at this point, and bug # 4122271 was noted only in the
context of listing the actual issue...  However, the
recommendation (even at that time) was to apply CU2.  Now, we recommend RUP4.</snip>

Posted by Steven Chan on December 13, 2006 at 03:11 AM PST #

thank you for answers! i run RUP4.
i have found one more trick for single node system:
it is possible to edit DB and techstack context files to change dbhost->localhost and dbdomain->localdomain. Now DBlistener listen only localhost ( and 11i works correctly

Posted by Lev on December 25, 2006 at 05:17 AM PST #


I am unable to download this. please help me.

Posted by guest on April 03, 2013 at 04:17 AM PDT #

Hi, Guest,

Older OpenWorld presentations go offline after about a year. I'm afraid that these materials aren't available for download any more.


Posted by Steven Chan on April 03, 2013 at 08:30 AM PDT #

Is there any alternative to download the same.

Posted by guest on April 03, 2013 at 11:25 PM PDT #

Hello, Guest,

I'm afraid that these older downloads aren't available any more. You can monitor or subscribe to this blog to be informed when new ones are available from our upcoming conferences this year.


Posted by Steven Chan on April 04, 2013 at 06:31 AM PDT #

Post a Comment:
  • HTML Syntax: NOT allowed


« July 2016