init.ora of TPC-C world record database

I was skimming the TPC benchmark disclosure report at http://www.tpc.org/results/FDR/TPCC/...050412_FDR.pdf

Thought folks might be interested in the init.ora of the database. Tons of undocumented parameters..


p_run.ora

compatible = 10.1.0.0.0
_NUMA_pool_size = 536870912
_collect_undo_stats=false
_awr_restrict_mode=true
_db_writer_flush_imu=false
timed_statistics = FALSE
query_rewrite_enabled=false
db_name = tpcc
control_files = /home/oracle/db/control_001
dml_locks = 500
log_buffer = 67108864 # 1048576x cpu
parallel_max_servers = 0
parallel_min_servers = 0
db_files = 3000
fast_start_io_target = 0
db_cache_size = 176000M
db_2k_cache_size = 2048M
db_16k_cache_size = 99000M
db_keep_cache_size = 600000M
db_recycle_cache_size = 64000M
enqueue_resources = 60000
processes = 2000
sessions = 3000
transactions = 2800
shared_pool_size = 14000M
cursor_space_for_time = TRUE
db_block_size = 4096
undo_management = auto
UNDO_TABLESPACE = undo_1
_db_cache_pre_warm=FALSE
trace_enabled = FALSE
db_block_checksum = FALSE
trace_enabled = FALSE
statistics_level = basic
plsql_optimize_level = 2
pga_aggregate_target = 0
_undo_autotune = false
undo_retention = 1
_imu_pools = 358
_optimizer_cache_stats = false
_optimizer_cost_model = io
fast_start_mttr_target = 0
db_writer_processes = 16
log_checkpoint_interval = 453701520
log_checkpoints_to_alert = TRUE
log_checkpoint_timeout = 1700
java_pool_size = 0
remote_login_passwordfile = shared
disk_asynch_io = TRUE
db_block_checking = FALSE
cursor_space_for_time = TRUE
lock_sga = TRUE
replication_dependency_tracking = FALSE
db_file_multiblock_read_count = 1
_cursor_cache_frame_bind_memory = true
max_dump_file_size=5M
_db_writer_coalesce_area_size = 16777216
aq_tm_processes = 0
_kghdsidx_count = 1
_ksmg_granule_size=268435456
_two_pass=false
_session_idle_bit_latches=3000
utl_file_dir=*

well a totally unrealistic parameter file - shows how worthwhile those tests are

Not a _go_faster = true in sight. I always knew they weren't telling us everything.

But at least they kept an eye on security.

Quote:

---

utl_file_dir=*

---

:rolleyes:

and one control file .....

and if i read that right a 14gb shared pool and 176gb buffer cache

and an undo retention of 1 second

pile of junk...

and remote_login_passwordfile = shared would certainly raise our auditors eyebrows

LOL wonder what would happen if someone were to take that init.ora bring the memory stuff down to reasonable levels then throw it on a test box to see what would happen.hmmmmmmm

Quote:

---

db_file_multiblock_read_count = 1

---

Yeah, wouldn't want to risk any "dangerous" full table scans.