Oracle's Complete Data Warehousing Solution Delivers World Record Result

(As of Wednesday, 13 October 2010)

Oracle delivers a world record single-system TPC-H data-warehousing benchmark result at the 3000 GB scale factor. This outstanding result highlights the effectiveness of a complete solution built exclusively on Oracle software and hardware. The superior scalability and integration of Oracle Database 11g Release 2, Oracle Solaris 10, and Oracle's Sun SPARC Enterprise servers and Sun Storage families delivered the best performance among all competing single-system solutions, beating the best results posted by IBM at 3000 GB.

The TPC-H benchmark was established by the Transaction Processing Council (TPC) to enable customers to evaluate the performance of various Business Intelligence/Data Warehousing (BIDW) and Decision Support Systems (DSS) systems for various standard database sizes, referred to as the scale factor (SF). The benchmark measures the combined performance of a particular database manager on a specific computer system at various scale factors, including 100 GB, 300 GB, 1000 GB, 3000 GB, 10000 GB, and 30000 GB, and reports the composite TPC-H Query-per-Hour (QphH) performance metric, as well as the price/performance metric, which is the total cost of the solution, consisting of hardware, software, and three-year maintenance costs divided by the QphH.

Oracle's largest multiprocessor enterprise-class server, the Sun SPARC Enterprise M9000, posted a world record non-clustered result of 198,907.5 QphH@3000 GB with a price of $16.58 per QphH@3000 GB.

This leading TPC-H benchmark utilized the 2.88 GHz SPARC64 VII processor-based Sun SPARC Enterprise M9000 server running Oracle Solaris 10 and Oracle Database 11g. Oracle Solaris 10 is a leading enterprise operating system that provides best-in-class reliability, security, and scalability an includes Solaris Volume Manager (SVM) software. SVM enables efficient and protected data placement and was used to manage all database files across Oracle's Sun Storage 6180 arrays. This approach allowed for 2.7x faster database load times than the IBM Power 595 configuration.

Using the same number processors, the Sun SPARC Enterprise M9000 server outperformed the best IBM single-system result, posted by the IBM Power 595, by 27 percent while demonstrating better three-year TCO. According to TPC-H rules, the price of the solution is calculated for hardware, software, and maintenance over a three-year period. This highlights Oracle's focus on integrated system design and performance of the complete hardware and software solution.

Demonstrating superior I/O throughput when coupled with Oracle Solaris and Oracle Database 11g, the Sun SPARC Enterprise M9000 delivered data rates of 18 GB/sec.

The benchmark underscores the ability of Sun SPARC Enterprise M-series servers to handle the increasingly large databases required of DSS systems and demonstrates the performance capabilities of multi-processor SPARC systems in the most demanding enterprise application environments.

Oracle is a registered trademark of Oracle Corporation and/or its affiliates. TPC Benchmark H, TPC-H, QphH are trademarks of the Transaction Performance Processing Council (TPC). More info http://www.tpc.org. Other names may be trademarks of their respective owners.