Performance Tuning for the E-Business Suite

It's said that death and taxes are the only certainties.  I beg to differ.  There's at least one other for IT professionals:  regardless of the amount of network bandwidth you've dedicated to E-Business Suite traffic, no matter how many application servers you have in your load-balancing pool, no matter the turbocharged fire-breathing database server you've got in your data center, it's inevitable that your users will complain about performance. 

Apps DB Console Screenshot: Screenshot of E-Business Suite Database Console showing Host queues,Waiting and Working Sessions, Instance Throughput, and other performance metrics

In my promised but much-belated recap of OpenWorld 2007 highlights for Apps DBAs, here's a presentation from Isam Alyousfi and Lester Gutierrez that you much check out:
Isam and Lester are key members of our Oracle Applications Performance Group -- the same group that publishes all of the official Oracle Apps benchmarks, white papers, and performance metrics.

In this sprawling presentation, they cover the following topics:
  •  E-Business Suite Architecture and techstack from a performance perspective
  • Tuning the Applications Tier, including:
    • Forms & Reports tracing and tuning
    • Concurrent Manager tracing and tuning
    • PL/SQL Profiler usage and tips
    • Apache JServ/OC4J optimization and configuration tips
    • How to debug Java memory and connection leaks
    • OA Framework tracing
    • AOL/J Connection Pool monitoring
    • Discoverer tuning
  • Tuning the Database Tier, including:
    • I/O considerations
    • Automatic Workload Repository (AWR) data interpretation
    • Use of the DB Console
    • How to gather and interpret statistics
    • Use of the Applications Tablespace Migration Utility
    • 10g DB upgrades from a performance perspective
  • Client and Network Tuning, including:
    • Memory usage and profiles for Apps 11i and R12
    • Network performance and bandwidth considerations
  • Application Tuning, including specific tips for:
    • Workflow
    • Order Management
    • Payroll
    • Financials
    • TCA/DQM
    • Logging
    • Profile usage
    • Purging and archiving
  • And much, much more
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.

Related

Comments:

Steve - I had attended your sessions in OOW 2007 and you had mentioned the name of Bret Fuller for the "ORACLE @ ORACLE" details. But this presentation is not on the link for download. Is it possible to get the presentation for this ?

Thanks

Posted by Nandita Saigal on December 12, 2007 at 01:35 AM PST #

Nandita,I've asked Bret whether he's posted this for download somewhere.  I'll follow up with more details as soon as I get a link.  In the meantime, you can check out his presentation from last year's OOW:Case Study: Oracle's Own E-Business Suite Global Single Instance - http://blogs.oracle.com/schan/2006/07/12/You'll also find some tips from our internal Release 12 upgrade in Eugene Weinstein's presentation here:Best Practices for Upgrading to Release 12 - http://blogs.oracle.com/schan/2007/11/best_practices_for_upgrading_t.htmlRegards,Steven 

Posted by Steven Chan on December 12, 2007 at 01:40 AM PST #

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
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today