Oracle Training Oracle Support Development Oracle Apps

 E-mail Us
 Oracle Articles
New Oracle Articles

 Oracle Training
 Oracle Tips

 Oracle Forum
 Class Catalog

 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Oracle Support

 SQL Tuning

 Oracle UNIX
 Oracle Linux
 Remote s
 Remote plans
 Application Server

 Oracle Forms
 Oracle Portal
 App Upgrades
 SQL Server
 Oracle Concepts
 Software Support

 Remote S


 Consulting Staff
 Consulting Prices
 Help Wanted!


 Oracle Posters
 Oracle Books

 Oracle Scripts

Don Burleson Blog 







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):  

“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:

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)



aq_tm_processes = 0

audit_trail = FALSE

compatible =

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 =

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


Oracle Training at Sea
oracle dba poster

Follow us on Twitter 
Oracle performance tuning software 
Oracle Linux poster


Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  

and include the URL for the page.


Burleson Consulting

The Oracle of Database Support

Oracle Performance Tuning

Remote DBA Services


Copyright © 1996 -  2017

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.

Remote Emergency Support provided by Conversational