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=*