Get over a quarter million transactions per second on Windows with Oracle10g Oracle Tips by Burleson Consulting

UNISYS Corporation recently published a stunning TPC-C benchmark showing over 250,000 transactions per second on a Windows-based server using Oracle10g

While the details of the benchmark are included in the link, the high speed was primarily as result of these factors:

• Multiple blocksizes

• 115 gigabyte total data buffer cache

• 78 gigabyte KEEP pool

• 16 CPU Server – Each a 64-bit Itanium 2 Processor

In this UNISYS benchmark they achieved a stunning 291,410 transactions per minute.

To understand the Oracle component, here are a few of the Oracle10g parameters that were used in the benchmark:

db_block_size = 2048
db_16k_cache_size = 15010M
db_8k_cache_size = 1024M
db_cache_size = 8096M
db_keep_cache_size = 78000M
db_recycle_cache_size = 15400M
db_writer_processes = 4
pga_aggregate_target = 0
sort_area_size = 65525

Also of interest is the Oracle10g Windows registry entry ora_lpenable for large page support:

"ORA_LPENABLE" = "1"

This tells Oracle to use the Large Page feature (available in Oracle9i 64-bit for Windows and Oracle10g 32-bit and 64-bit for Windows).