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
|
