It's not highly visible, but we have a team within the Applications Technology Group that's dedicated to optimizing the performance of the E-Business Suite.
This group covers it all: runtime performance analysis for the database, application and client tiers, as well as performance analysis of our own internal development environments. At any given time, they can be found analyzing JVM garbage collection parameters, JDBC connection pool logs, network roundtrips and latency, process address space allocations, and other related esoterica.
Interesting trivia: they maintain a comprehensive SQL repository with over 500,000 SQL statements used in a given E-Business Suite release, extracted directly from the source code, and the execution plans of these SQL statements based on volume-testing databases. E-Business Suite developers use this database to identify potential performance issues with their specific apps products.
Our performance team also works with selected vendors to create standardized (and independently audited) Applications Benchmarks. As of today, benchmarks are available for 11.5.9 and 11.5.10. Interesting reading.
Note: The graph shown above is for the Oracle e-Business Suite eBS Benchmark 11.5.10 using Oracle10g on HP ProLiant and Blade servers.
Comments (2)
Hi Steven, How does the team load test a system? We have been looking into products to load test our instance before go-live and were shocked by the price of Load Runner but have not found any less expensive products that work with OAF pages.
Thanks,
Mark
Posted by Mark Harrington | June 1, 2006 6:52 AM
Posted on June 1, 2006 06:52
Hi, Mark,A timely question... I'd been thinking about writing about this for a while. In response to your suggestion, I've just posted this:Automated Testing for the E-Business SuiteI'm not personally familiar with Mercury's pricing terms, but it doesn't surprise me to hear your reaction. If I were in a position to evaluate the cost-benefit equation, I'd think have to look carefully at how much testing time the tool can save you. The more end-users you have, the more power they have to veto new patches. So, a number of our enterprise (read: LARGE) customers see this investment in strategic terms: they enlist the help of their end-user community in building the tests initially, which reduces the anxiety and resistance around applying new patches. Regards,Steven
Posted by Steven Chan | June 1, 2006 1:49 PM
Posted on June 1, 2006 13:49