Everything you want and need to know about Oracle SPARC systems performance

SPARC T3-2 Delivers First Oracle E-Business X-Large Benchmark Self-Service (OLTP) Result

Guest Author

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.

Performance Landscape

This is the FIRST published result for this X-large benchmark.

Workload HR Self-Service
X-Large Configuration
Vendor/System OS Users
SPARC T3-2 Oracle Solaris 10 9/10 4000

Results and Configuration Summary

Application Tier Configuration:

1 x SPARC T3-2 server
2 x SPARC T3 processors, 1.65 GHz
128 GB memory
Oracle Solaris 10 9/10
Oracle E-Business Suite 12.1.2

Database Tier Configuration:

1 x Sun SPARC Enterprise M5000 server
4 x SPARC64 VII processors, 2.53 GHz
128 GB memory
Oracle Solaris 10 10/09
Oracle Database 11g Release 2

Storage Configuration:

1 x Sun Storage F5100 Flash Array storage
1 x StorageTek 2540 array
300 GB

Benchmark Description

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.

See Also

Disclosure Statement

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.

Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.