Oracle breaks another TPC-H world speed record

Sun Microsystems broke a new world’s record data warehouse (TPC-H) benchmark using a high-powered 5.7 million dollar server with 72 CPUs, with an astonishing 1,500 query-per-Hour Performance Metric (QphH@Size):

http://www.oracle.com/corporate/press/2006_jan/tpch_sun_013006.html?msgid=4580463

“Running on a single Sun Fire™ 25K server with 72 UltraSPARC IV+ 1.5 GHz processors and the Solaris™ 10 Operating System (OS), Oracle Database 10g Release 2 with Automatic Storage Management achieved a record-breaking performance of 105,430.9 QphH@3000GB with a price-performance ratio of $54.87/QphH@3000GB. Oracle Automatic Storage Management . . . "Oracle Database 10g Release 2 repeatedly demonstrates its superior fit in demanding data warehouse environments, " said Richard Sarwal, vice president of Server Performance, Oracle. "The addition of this benchmark helps to prove that no matter how much our customers' data warehouses grow, the Oracle Database will continue to deliver the best, most consistent database performance."”

The benchmark details are published here:

http://www.tpc.org/tpch/results/tpch_result_detail.asp?id=106012701

http://www.tpc.org/results/FDR/tpch/sun_fire_e25k_3tb_012706_fdr.pdf

In the TPC-H disclosure report we see the Oracle initialization parameters and these chosen high-performance settings:

32k blocksize
50g PGA region size
90g SGA target

Here is their listing of the Oracle and Solaris parameters used in this benchmark:

Oracle 10g Parameters
(altered from default)

===================================================

inittpch.ora

aq_tm_processes = 0
audit_trail = FALSE
compatible = 10.2.0.1
control_files = /ff1/control.dbf
db_block_checksum = FALSE
db_block_size = 32768
db_create_file_dest = +dg_tpch
db_file_multiblock_read_count = 32
db_files = 1023
db_name = tpch
db_writer_processes = 20
dml_locks = 80000
global_names = FALSE
java_pool_size = 0
log_checkpoints_to_alert = TRUE
max_dump_file_size = unlimited
nls_date_format = YYYY-MM-DD
open_cursors = 1024
optimizer_features_enable = 10.2.0.1.1
optimizer_mode = CHOOSE
parallel_execution_message_size = 32768
parallel_max_servers = 2000
parallel_min_servers = 1700
parallel_threads_per_cpu = 1
pga_aggregate_target =50g
processes = 4000
recovery_parallelism = 64
replication_dependency_tracking = FALSE
sessions = 2048
sga_target = 90g
undo_management = AUTO
undo_tablespace = ts_undo
===================================================

Solaris Parameters
(altered from default)

===================================================
set shmsys:shminfo_shmmax=0xffffffffffffffff
set shmsys:shminfo_shmseg=200
set msgsys:msginfo_msgmax=1048576
set msgsys:msginfo_msgmnb=4194304
set msgsys:msginfo_msgmni=4400
set msgsys:msginfo_msgtql=32768
set msgsys:msginfo_msgseg=32767
set msgsys:msginfo_msgssz=128
set msgsys:msginfo_msgmap=3002
set semsys:seminfo_semmap=100
set semsys:seminfo_semmni=8000
set semsys:seminfo_semmns=8000
set semsys:seminfo_semmnu=8000
set semsys:seminfo_semmsl=512
set semsys:seminfo_semume=100
set maxpgio=131072
set maxphys=4194304
set autoup=900
set bufhwm=8000
set segspt_minfree=16000
set kernel_cage_enable=0
set segmap_percent=1
set lgrp_mem_pset_aware=0x1