World Record Oracle Business Intelligence Benchmark on SPARC T4-4
- by Brian
Oracle's SPARC T4-4 server configured with
four SPARC T4 3.0 GHz processors
delivered the first and best performance of 25,000
concurrent users on Oracle Business Intelligence Enterprise Edition
(BI EE)
11g benchmark using
Oracle Database 11g Release 2 running on
Oracle Solaris 10.
A SPARC T4-4 server running Oracle Business Intelligence Enterprise
Edition 11g achieved 25,000 concurrent
users with an average response
time of 0.36 seconds with Oracle BI server cache set to ON.
The benchmark data clearly shows that the underlying hardware, SPARC T4
server, and the Oracle BI EE 11g (11.1.1.6.0 64-bit)
platform scales within a single
system supporting 25,000 concurrent users while executing 415
transactions/sec.
The benchmark demonstrated the scalability of Oracle Business
Intelligence Enterprise Edition 11g 11.1.1.6.0,
which was deployed in a
vertical scale-out fashion on a single SPARC T4-4 server.
Oracle Internet Directory configured on SPARC T4 server provided
authentication for the 25,000 Oracle BI EE users
with sub-second response time.
A SPARC T4-4 with internal Solid State Drive (SSD) using the ZFS file system
showed significant I/O performance improvement over traditional disk
for the Web Catalog activity. In addition, ZFS helped get past the UFS
limitation of 32767 sub-directories in a Web Catalog directory.
The multi-threaded 64-bit Oracle Business Intelligence Enterprise
Edition 11g and SPARC T4-4 server proved to be a successful
combination by providing sub-second response times for the end user
transactions, consuming only half of the available CPU resources at
25,000 concurrent users, leaving plenty of head room for increased
load.
The Oracle Business Intelligence on SPARC T4-4 server benchmark results
demonstrate that comprehensive BI functionality built on a unified
infrastructure with a unified business model yields
best-in-class scalability, reliability and performance.
Oracle BI EE 11g is a newer
version of Business Intelligence Suite with
richer and superior functionality.
Results produced with Oracle BI EE 11g benchmark are not
comparable to results with Oracle BI EE 10g benchmark.
Oracle BI EE 11g is a more difficult benchmark
to run, exercising more features of Oracle BI.
Performance Landscape
Results for the Oracle BI EE 11g version of the benchmark.
Results
are not comparable to the Oracle BI EE 10g
version of the benchmark.
Oracle BI EE 11g Benchmark
System
Number of Users
Response Time (sec)
1 x SPARC T4-4 (4 x SPARC T4 3.0 GHz)
25,000
0.36
Results for the Oracle BI EE 10g version
of the benchmark. Results
are not comparable to the Oracle BI EE 11g
version of the benchmark.
Oracle BI EE 10g Benchmark
System
Number of Users
2 x SPARC T5440 (4 x SPARC T2+ 1.6 GHz)
50,000
1 x SPARC T5440 (4 x SPARC T2+ 1.6 GHz)
28,000
Configuration Summary
Hardware Configuration:
SPARC T4-4 server
4 x SPARC T4-4 processors, 3.0 GHz
128 GB memory
4 x 300 GB internal SSD
Storage Configuration:
">
Sun ZFS Storage 7120
16 x 146 GB disks
Software Configuration:
Oracle Solaris 10 8/11
Oracle Solaris Studio 12.1
Oracle Business Intelligence Enterprise Edition 11g (11.1.1.6.0)
Oracle WebLogic Server 10.3.5
Oracle Internet Directory 11.1.1.6.0
Oracle Database 11g Release 2
Benchmark Description
Oracle Business Intelligence Enterprise Edition (Oracle BI EE) delivers a robust set
of reporting, ad-hoc query and analysis, OLAP, dashboard, and scorecard
functionality with a rich end-user experience that includes
visualization, collaboration, and more.
The Oracle BI EE benchmark test used
five different business user roles
- Marketing Executive, Sales Representative, Sales Manager, Sales
Vice-President, and Service Manager. These roles included a maximum of
5 different pre-built dashboards. Each dashboard page had an average of
5 reports in the form of a mix of charts, tables and pivot tables,
returning anywhere from 50 rows to approximately 500 rows of aggregated
data. The test scenario also included drill-down into multiple levels
from a table or chart within a dashboard.
The benchmark test scenario uses a typical business user sequence of
dashboard navigation, report viewing, and drill down. For example, a
Service Manager logs into the system and navigates to his own set of
dashboards using Service Manager. The BI user selects the Service
Effectiveness dashboard, which shows him four distinct reports,
Service Request Trend, First Time Fix Rate, Activity Problem Areas, and
Cost Per Completed Service Call spanning 2002 to 2005. The user then proceeds
to view the Customer Satisfaction dashboard, which also contains a set
of 4 related reports, drills down on some of the reports to see the
detail data. The BI user continues to view more dashboards
– Customer
Satisfaction and Service Request Overview, for example. After
navigating through those dashboards, the user logs out of the
application.
The benchmark test is executed against a full production
version of the Oracle Business Intelligence 11g
Applications with a
fully populated underlying database schema.
The business processes in the test scenario closely represent
a real world customer scenario.
See Also
SPARC T4-4 Server
oracle.com
OTN
Oracle Business Intelligence
oracle.com
OTN
Oracle Database 11g Release 2 Enterprise Edition
oracle.com
OTN
WebLogic Suite
oracle.com
OTN
Oracle Solaris
oracle.com
OTN
Disclosure Statement
Copyright 2012, 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 30 September 2012.
