SPARC T4-4 Produces World Record Oracle OLAP Capacity
By Brian-Oracle on Oct 03, 2011
Oracle's SPARC T4-4 server delivered world record capacity on the Oracle OLAP Perf workload.
The SPARC T4-4 server was able to operate on a cube with a 3 billion row fact table of sales data containing 4 dimensions which represents as many as 70 quintillion aggregate rows (70 followed by 18 zeros).
The SPARC T4-4 server supported 3,500 cube-queries/minute against the Oracle OLAP cube with an average response time of 1.5 seconds and the median response time of 0.15 seconds.
|Oracle OLAP Perf Benchmark|
Num of Rows
|SPARC T4-4||3 Billion||3,500||0.15||1.5|
Configuration Summary and Results
1 TB main memory
Oracle Database 11g Enterprise Edition with Oracle OLAP option
OLAP Perf is a workload designed to demonstrate and stress the Oracle OLAP product's core functionalities of fast query, fast update, and rich calculations on a dimensional model to support Enhanced Data Warehousing. The workload uses a set of realistic business intelligence (BI) queries that run against an OLAP cube.
Key Points and Best Practices
The SPARC T4-4 server is estimated to support 2,400 interactive users with this fast response time assuming only 5 seconds between query requests.
Oracle Database 11g - Oracle OLAP
- SPARC T4-4 Server
Oracle Database 11g Release 2 Enterprise Edition
Copyright 2011, 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 10/3/2011.