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