Oracle Database 11g and SPARC Enterprise M9000 Server Double Previous Data Warehousing World Record

BENCHMARK SUMMARY

(As of Tuesday, 22 March 2011)

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 SPARC Enterprise M-series servers and Sun Storage 6180 arrays delivered the best performance among all competing single-system solutions, beating the best published IBM result at the 3000 GB scale factor by 2.5 times.

BENCHMARK DESCRIPTION

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.

BENCHMARK OUTCOME

  SPARC Enterprise M9000 SPARC Enterprise M9000 IBM Power 595
Performance (QphH) 386,478.3 198,907.5 156,537
Price/Performance (US$/QphH) 19.25 16.58 20.60
Database Oracle 11g Release 2 Oracle 11g Release 2 Sybase IQ
Operating System (OS) Oracle Solaris 10 Oracle Solaris 10 AIX 6.1
Availability Date 09/22/11 12/09/10 11/24/09
  • The SPARC Enterprise M9000 server running the Oracle Database 11g Release 2 software outperformed the best IBM single-system result, posted by the IBM Power 595 running Sybase IQ database software, by 2.5x 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.
  • Oracle's largest multiprocessor enterprise-class server, the SPARC Enterprise M9000, posted a world record non-clustered result of 386,478.3 QphH@3000 GB with a price of $19.25 per QphH@3000 GB. This leading TPC-H benchmark utilized the SPARC Enterprise M9000 server, equipped with the latest 3 GHz SPARC64 VII+ processors and 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.
  • Oracle Automatic Storage Management (ASM) was used to manage all database files across Oracle's Sun Storage 6180 arrays. Moreover, mirroring was used to ensure complete data protection during benchmark execution and Atomicity, Consistency, Isolation, and Durability (ACID) testing. This approach enabled efficient and protected data placement as well as provided the highest scan rate and up to 3.4x faster database load times than the IBM Power 595 configuration.
  • The SPARC Enterprise M9000 server configured with Sun Storage 6180 arrays shows linear scaling up to the maximum delivered I/O performance of over 48 GB/sec., as reported by a standard I/O test called VDbench.
  • The SPARC Enterprise M9000 server, equipped with SPARC64 VII+ processors, shows near linear scalability and 1.94x performance improvement compared to the previous SPARC Enterprise M9000 server result with SPARC64 VII processors. This leading benchmark result 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.spec.org Other names may be trademarks of their respective owners.

Oracle 1-800-633-0738