UNISYS的测试声称oracle10g可以进行每秒二十五万以上的事务处理，当然硬件的配置是比较吓人的。
这个新闻只是看一下就可以了，只是其中提到的测试环境是基于windows的oracle10g，看来windows版本的应该在不久就可以发布了，目前Oracle Database 10g Release 1 (10.1.0.2) for AIX5L 和 Oracle Database 10g Release 1 (10.1.0.2) for Tru64 UNIX 也即将发布。


Get over a quarter million transactions per second on Windows with Oracle10g

February 26, 2004
Don Burleson

Special thanks to Carol Spencer for providing the details on this benchmark

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

http://www.tpc.org/results/FDR/T ... 291K_040209_fdr.pdf


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