Performance & Best Practices

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.

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:

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.

About

BestPerf is the source of Oracle performance expertise. In this blog, Oracle's Strategic Applications Engineering group explores Oracle's performance results and shares best practices learned from working on Enterprise-wide Applications.