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:
Related