Tuning the Oracle E-Business Suite Environment (OpenWorld 2009 Recap)

In addition to their benchmarking efforts, our Applications Performance Group works with some of our largest E-Business Suite customers in the world.  These customers have thousands of concurrent end-users, sprawling multi-terabyte databases, enormous clusters of application-tier servers, and massive RAC architectures.  The Applications Performance Group is called in whenever a customer experiences severe performance issues. 

Every year, our performance architects take all of their hard-won experience with these customers and distill it into a single OpenWorld presentation.  Wondering how many JVMs to use per CPU?  Curious about tuning the garbage collection parameters on your app tier?  Want some tips for optimizing your Concurrent manager setup?

Isam Alyousfi and Lester Gutierrez cover these topics, and much, much more, in their densely-packed presentation:

db_console_screenshot.png

It's difficult to convey the depth and range of the performance-tuning tips that they capture, but here's an outline of the topics that they cover:
  • Tuning the applications tier
    • Pointers to resources and performance-related patches
    • Tips for tuning and debugging Forms
    • OC4J and JVM sizing guidelines (e.g. number of JVMs per CPU, number of users per JVM)
    • Tools for tuning the application tier
    • Diagnostic framework for investigating response time / CPU issues
    • Garbage collection (GC) tuning tips
    • Common causes of OutOfMemoryError conditions
    • Symptoms of memory leaks
    • Using JDBC connection identification to map JDBC sessions to a JVM process
    • Performance implications of end-user training on web application resource consumption
    • Using the Pool Monitor to check Framework applications and JVM utilization
    • Using EM Monitoring and Application Diagnostics for Java (AD4J) to monitor JVMs on different hosts
    • Using JConsole to analyze heap dump issues
    • Performance-related patches to consider
  • Tuning the Concurrent Manager
    • General tips for maximizing job throughput
    • Tips for workload management, including the number of target processes per CPU
    • Tips for Transaction Managers (TMs)
    • Tips for tracing and speeding up Concurrent Reports
    • Using Parallel Concurrent Processing (PCP) in RAC deployments
  • Tuning the client tier and network
    • Pointers to a new whitepaper, and tips for optimizing desktop client configurations
    • Tips for reducing browser memory footprints
    • Guidance on network latency and co-locating database and application tier servers
    • Network profiling and packet analysis techniques
    • Use of caching tools to reduce network traffic between client and middle-tiers
  • Tuning the database tier
    • init.ora recommended settings
    • Consequences of undersized buffer caches or shared pools
    • I/O optimization techniques
    • Recommended performance features
    • Using Automatic Workload Repository (AWR) data and baselines
    • Linking AWR with ASH data
    • Tips for using DB Console
    • Techniques for gathering statistics
    • Recommendations for OATM Tablespace Model conversions
    • SQL issue triage notes, and common problems
    • Benefits of upgrading to 11g Database
    • Notable performance-related features in the 11g Database
    • Advanced Compression performance benchmarks
    • 11g Automatic SQL monitoring and tuning
    • SQL tracing enhancements in 11g DB
    • 11g Optimizer improvements
  • Tuning the applications
    • Pointers to application module tuning resources
    • Recommended performance-related patches and configuration guidance for specific products: Create Accounting XLA, Accounts Receivables AR, Accounts Payables AP, iPayment IBY, Incentive Compensation CN, Time & Labor, Workflow, Order Management OM, Payroll
    • Logging, purging, and archiving
    • Accessing the Purge Portal
  • Upgrade performance 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.

Listening to the Session

If you registered for OpenWorld, here's a link to the OpenWorld On Demand page where you can download the presentation or listen to the live recording of this session.

Related Articles
Comments:

Hi Steve.

Excellent Information.

Thanks bunch.

Santosh.

Posted by santosh on November 24, 2009 at 10:06 PM PST #

Hi Steven,

Thank you for highlighting these great sessions that we might have missed during OpenWorld. The information is so well organized here and the Listening to the Session points to the OpenWorld On Demand page was a great help too.

Many thanks for your recommendations and time-saving efforts!

Best Regards,
Jennifer.

Posted by Jennifer Chen on November 25, 2009 at 04:00 AM PST #

Steven,

After reviewing the presentation, I went back to Note 244040.1 to see where I stood on recommended database performance patches. I was dismayed to find that despite being on the latest PSU (11.1.0.7.1), I had 0 of the 9 patches I checked. Would you think these might be included in a future PSU, or is there any chance we might see an performance "umbrella" patch (similar to a PSU) for 11i customers?

Posted by Kevin Kempf on December 02, 2009 at 05:13 AM PST #

Hi, Kevin,

I hear you. The challenge is that the patches listed in Note 244040.1 do not meet the Database division's criteria for inclusion in the quarterly Patch Set Updates (PSU). I'll pass your comment on to the Applications Performance Group to see if they can use this as additional justification for expanding the scope of the PSUs to include these patches.

Regards,
Steven

Posted by Steven Chan on December 03, 2009 at 06:40 AM PST #

Tuning is very important for the performance aspect .Thanks for giving guideline for tuning for each tier.

Posted by Software development india on December 06, 2009 at 07:36 PM PST #

Steven,

After I posted my comment, I went to apply performance patches per 244040.1 to my regression test environment. Of the 9 patches I pulled (which included Advanced Compression patches), all but 4 conflicted with PSU 1009. I'm less than enthusiastic about having to contact support for a custom merge patch every quarter when a PSU comes out. Don't know if that helps the case any, but in my case, it's a show stopper for the performance patches.

Posted by Kevin Kempf on December 06, 2009 at 10:30 PM PST #

Hi, Kevin,

Thanks for letting me know about your experiences with the PSU vs. the EBS performance patches. I've passed these additional comments along to the Apps Performance Group and the ST group that owns the PSUs; I'm sure that they'll find this feedback valuable.

Regards,
Steven

Posted by Steven Chan on December 07, 2009 at 06:09 AM PST #

Hi Steven-
I am looking for recommendations on the IE 8 settings for Browser Cache Size (MB) and Browser Cache Update Policy for IE 8 for Oracle Financials 11i.

Having Browser Cache Size (MB) = 1000 and Browser Cache Update Policy = 'Automatic' - help in reducing the network traffic and improve user response time?

Isn't Browser Cache Update Policy = 'Automatic' better than Browser Cache Update Policy = 'Every Visit to the page'?

Thanks.
Anuj.

Posted by guest on March 22, 2012 at 11:36 AM PDT #

Hi Anuj,

Oracle does not recommend any particular browser cache size for EBS. The best size can also be dependent on non EBS activity in the browser cache. Certainly a setting of 1000 would seem excessive in most cases and could end up having a detrimental effect. Microsoft recommend 50-250 which is sufficient for EBS.
Regarding the cache policy, while 'Automatic' has a performance advantage over 'Every Visit to the Web Page', if using HTML pages within EBS it can be preferable to run with the latter to ensure you are viewing the most recent information within the pages.

Regards,
Tim.

Posted by guest on March 29, 2012 at 05:06 AM PDT #

Post a Comment:
  • HTML Syntax: NOT allowed
About

Search

Categories
Archives
« April 2014
SunMonTueWedThuFriSat
  
1
4
5
6
7
8
9
10
11
12
13
14
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today