SPARC T5-8 Produces Oracle Database 12c OLAP World Record
(As of Sunday, 22 September 2013)
Oracle's SPARC T5-8 server delivered world record query performance, together with a near real-time analytic capability, using the Oracle OLAP Perf Version 3 workload running Oracle Database 12c Release 1(126.96.36.199) on Oracle Solaris 11. The SPARC T5-8 server provided greater query per hour performance throughput while supporting more concurrent OLAP users compared to an eight-chip server running an Intel Xeon E7-8870.
The Oracle OLAP Perf Version 3 benchmark is a workload designed to demonstrate and stress the Oracle OLAP product's core capabilities of fast query, near real-time updates, and rich calculations. The benchmark uses a multi-dimensional model to support enhanced data warehousing.
The bulk of the benchmark entails running a number of concurrent users, each issuing typical multidimensional queries against an Oracle OLAP cube. In version 3 of the OLAP benchmark, the cube size was a 4 billion row cube. The cube has four dimensions: time, product, customer, and channel. Each query user issues approximately 150 different queries.
The purpose of the demonstration is to show that an Oracle OLAP system can be designed which results in data being no more than a few minutes out of date. This is what is meant by near real-time analytics.
Queries / Hour
0 Second Think Time
60 Second Think Time
8-Chip Intel Xeon E7-8870
The SPARC T5-8 server with Oracle Database 12c is capable of supporting 700 concurrent OLAP query users (with zero think time) which process 2.329 million analytic and aggregate queries per hour with an average response time of 0.98 seconds.
This performance was enabled by keeping the entire cube in-memory utilizing the 4 TB of memory on the SPARC T5-8 server. The cube was updated every 6 minutes with 10,000 new rows of data, simultaneously with the query workload providing query users with near real-time information.
The SPARC T5-8 server outperformed the 8-chip Intel Xeon E7-8870 server configured with 1 TB of memory by a factor of 1.7 with respect to the query throughput.
Copyright 2013, 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 09/22/2013.