The only EBS R12 official benchmarks published are on IBM Power. Last Summer 2008 Oracle with IBM conducted a benchmark in the Oracle/IBM Joint solution Center (my team !!!) in Montpellier (France). This benchmark was Telco oriented and the goal was to measure the online and batch performance of Receivables (AR) flows in an environnement running Oracle E-business suite R12 with Oracle 10g RAC on IBM Power platform. The Oracle E-Business suite was interfaced with an external billing system (like Oracle Billing and Revenue Management (BRM)). The high volumes were AR (Receivables), XLA (Subledger Account), ZX (eTax), GL (General ledger). 
The OLTP challenges:
- Million of internet (Self-Service ) users
- High availability requirement
The Batches challenges :
- Time constraint
- Huge daily volumes: millions of daily batch transactions
- Daily peak load.
Other important elements for this benchmark was the Invoice and each Invoice had 11 Invoices Lines. So daily 2.6M invoices => 28M Invoices Lines. Multiple tables and indexes reaching or over 1Tb each example : RA_CUSTOMER_TRX_LINES_ALL (1,279,292,941 rows), GL_JE_LINES (1,299,945,389 rows) ,XLA_AE_LINES(2,204,107,706 rows) . I was extremely impressed when I executed a “select count(*) from XLA_AE_LINES;” to see more than 2,204,107,706 rows !!!! After more 20 years working with Oracle Database it was the most important Value I saw for a number of row into a Oracle Table.
The Team working on this benchmark was more than 20 people working 24/7 around the globe:
- Oracle Receivables Development team
- Oracle R12 Performance team
- Oracle EMEA Consulting – International Projects. Pascal Labrevois (THE MASTER !!!)
- Oracle RACPack
- Oracle/IBM Joint Solution Center (My TEAM here)
- IBM Benchmark team in Montpellier
- IBM PSSC DataCenter teams in Montpellier(Network team, Setup team, Storage team)
The technology used on this benchmark was fantastic : IBM Power using micropartitiong, Processor virtualization , Power5 and Power6 (5 Ghz), SMT (Simultaneous Multi-threading), New Generation of IBM SAN Storage DS 8300, Point in Time Copy Tool FlashCopy, from Oracle we used Automatic Storage Management (balancing), RMAN duplicate, Partitionning, Oracle Flashback Database Restore.
See below a list of Lessons learnt during this benchmark :
- Split the big tables/indexes over many tablespaces to reduce the backup/restore time
- Pre-allocate extents for partitioned objects with caution
- Create separate and dedicated environments for batch and OLTP fine tuning to reduce tuning opportunity contentions
- No manual steps, automate everything
- Duplicate and manage DB with ASM
- Deploy the Grid-Control certified with APPS
- Create one “admin” partition, share as most as possible files and data between partitions
- ASM allocations units changes will impact the database size
- Interpret and explain properly the CPU behavior and measurements with virtualization
References:
* E-Business Applications R12 (RUP 3) Receivables (Autoinvoice): Using Oracle10g on an IBM System p5 595 and an IBM System p6 595 (PDF)
* E-Business Applications R12 (RUP 3) Receivables Batch Processing: Using Oracle10g on an IBM System p5 595 (PDF)
* E-Business Applications R12 (RUP 3) Receivables Online Processing: Using Oracle10g on an IBM System p5 595 (PDF)