SPARC T3-2 Delivers First Oracle E-Business X-Large Benchmark Self-Service (OLTP) Result
By Brian Whitney on Sep 28, 2010
With Oracle's SPARC T3-2 server running the application and Oracle's Sun SPARC Enterprise M5000 server running the database, Oracle set a world record result for the Oracle E-Business Standard X-Large HR Self-Service (OLTP) benchmark.
The combination of a SPARC T3-2 server for the application and a Sun SPARC Enterprise M5000 server for the database achieved a result of 4000 HR Self-Service Online users on the Oracle E-Business X-Large benchmark dataset.
Oracle's Sun Storage F5100 Flash Array storage which was utilized in the benchmark was instrumental in obtaining an average transaction response time as low as 1.2 seconds.
Oracle has published the first Oracle E-Business R12.1.2 XL benchmark for 4000 HR Self-Service online users on a SPARC T3-2 server for the application tier and a Sun SPARC Enterprise M5000 server on database tier with Oracle 11g R2 database. Both servers ran with the Oracle Solaris 10 operating system.
The combination of the SPARC T3-2 server and Oracle E-Business R12.1.2 in the application tier with low CPU utilization provides headroom for growth.
The Sun Storage F5100 Flash Array storage provides higher performance with smaller footprint and lower power/cooling costs.
The result shows that the SPARC T3-2 server works well as a high capacity application server.
This is the FIRST published result for this X-large benchmark.
Workload HR Self-Service
|SPARC T3-2||Oracle Solaris 10 9/10||4000|
Results and Configuration Summary
Application Tier Configuration:
128 GB memory
Oracle Solaris 10 9/10
Oracle E-Business Suite 12.1.2
Database Tier Configuration:
128 GB memory
Oracle Solaris 10 10/09
Oracle Database 11g Release 2
The Oracle R12 E-Business Standard Benchmark combines online transaction execution by simulated users with concurrent batch processing to model a typical scenario for a global enterprise. This benchmark includes one online component and 2 batch components. The goal is to obtain reference response times and throughput for Oracle EBS R12. Results can be published in four configurations:
X-large: Maximum online users running all business flows between 10,000
to 20,000; 750,000 order to cash lines per hour and 250,000 payroll
checks per hour.
- HR Self-Service Online -- 4000 users
- The percentage across the 4 transactions in HR Self-Service module is:
- Create Query Cash Expense -- 20%
- Create Query Credit Expense -- 20%
- View Payslip -- 30%
- Create TimeCard -- 30%
- Customer Support Flow -- 8000 users
- Procure to Pay -- 2000 users
- Order to Cash -- 2400 users
- Large: 10,000 online users; 100,000 order to cash lines per hour and 100,000 payroll checks per hour.
- Medium: up to 3000 online users; 50,000 order to cash lines per hour and 10,000 payroll checks per hour.
- Small: up to 1000 online users; 10,000 order to cash lines per hour and 5,000 payroll checks per hour.
- Oracle R12 E-Business Standard Benchmark Results
- Oracle R12 E-Business Standard Benchmark Overview
- Oracle R12 E-Business Benchmark Description
- Dynamic SGA Tuning of Oracle Database on Oracle Solaris with DISM (pdf)
- Deploying Oracle Database on the Oracle Solaris Platform – An Introduction (pdf)
- Deploying Oracle Database on Oracle Sun SPARC Enterprise M-series Systems (pdf)
- Oracle's Optimized Solution for E-Business Suite (pdf)
Copyright 2010, Oracle and/or its affiliates. All rights reserved. Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners. Results as of 9/20/2010.