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:
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:
- Tuning the Oracle E-Business Suite Environment (Session S307954, PDF, 1.7 MB)
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:
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
- 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
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 (7)
Hi Steve.
Excellent Information.
Thanks bunch.
Santosh.
Posted by santosh | November 25, 2009 6:06 AM
Posted on November 25, 2009 06:06
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 | November 25, 2009 12:00 PM
Posted on November 25, 2009 12:00
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 | December 2, 2009 1:13 PM
Posted on December 2, 2009 13:13
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
|
December 3, 2009 2:40 PM
Posted on December 3, 2009 14:40
Tuning is very important for the performance aspect .Thanks for giving guideline for tuning for each tier.
Posted by Software development india | December 7, 2009 3:36 AM
Posted on December 7, 2009 03:36
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 | December 7, 2009 6:30 AM
Posted on December 7, 2009 06:30
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
|
December 7, 2009 2:09 PM
Posted on December 7, 2009 14:09