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.
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...
- Tuning the E-Business Suite (PDF, 2.0 MB)
(Username: cboracle, Password: oraclec6 to download)
- Pinning Objects to Improve Apps Performance
- Preventing Apps 11i Performance Issues in Four Steps
- Debugging General Performance Issues with Oracle Apps
- Performance Tuning the Apps Database Layer
- Performance and Tuning Improvements in Oracle's E-Business Suite (AppsCast with Ahmed Alomari and Cliff Godwin, MP3, 4.1 MB)
Comments (9)
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.
http://streaming.oracle.com/ebn/podcasts/applications/4662764.mp3
fadi hasweh
http://oracle-magic.blogspot.com
Posted by Fadi Hasweh | December 7, 2006 7:31 AM
Posted on December 7, 2006 07:31
I missed that one. This is excellent. Thanks!
Posted by Kevin Krause | December 7, 2006 9:33 AM
Posted on December 7, 2006 09:33
I concur about Ahmed. I remember Ahmed well from some very high-end joint Oracle/Sequent accounts way back when!
Posted by Kevin Closson | December 8, 2006 2:07 PM
Posted on December 8, 2006 14:07
Good suggestion, Fadi. I've added a link to that AppsCast to the article.Regards,Steven
Posted by Steven Chan | December 8, 2006 4:01 PM
Posted on December 8, 2006 16:01
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 | December 9, 2006 5:42 AM
Posted on December 9, 2006 05:42
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 | December 11, 2006 10:23 AM
Posted on December 11, 2006 10:23
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 | December 11, 2006 6:59 PM
Posted on December 11, 2006 18:59
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 | December 13, 2006 11:11 AM
Posted on December 13, 2006 11:11
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 (127.0.0.1) and 11i works correctly
Posted by Lev | December 25, 2006 1:17 PM
Posted on December 25, 2006 13:17