Sheila Jenkins Oracle News Headlines

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