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