Oracle has announced a new world-record TPC-H 10 Terabyte (TB) benchmark for Oracle Database 10g Release 2. With this achievement, Oracle now holds world records for the three largest scale factors in database performance. In all, Oracle holds four of the five TPC-H performance records:
- TPC-H 300 Gigabyte.
- TPC-H One TB.
- TPC-H Three TB.
- TPC-H 10 TB.
Running on a single Sun Fire E25K server with 72 UltraSPARC IV+ 1.5 GHz processors and Sun's Solaris 10 Operating System (OS), Oracle Database 10g Release 2 with Automatic Storage Management achieved a performance of 108,099.7/QphH@10000GB with a price-performance ratio of $53.80/QphH@10000GB.
Richard Sarwal, vice president of Server Performance at Oracle, said "While running complex queries against multiple terabytes of data was a rarity five years ago, it's becoming more common across all of our customers today."
Designed for grid computing, Oracle Database 10g delivers scalability, availability, security and ease of management on a low-cost grid of industry-standard storage and servers. Oracle Database 10g is designed to be effectively deployed on everything from small blade servers to the biggest SMP servers and clusters of all sizes. It features automated management capabilities. Oracle Database 10g's unique ability to manage data from traditional business information to XML documents and spatial/location information makes it suitable for power online transaction processing, decision support and content management applications.
TPC-H is a decision support benchmark consisting of a suite of business-oriented ad-hoc queries and concurrent data modifications. The performance metric is called the TPC-H Composite Query-per-Hour Performance Metric (QphH@Size) and reflects multiple aspects of the capability of the system to process queries.