玉面飞龙的BLOG

这些参数真的是能够让Oracle神奇的faster起来，它们都是创造过TPC纪录的设置。

参考2份TPC参数设置。

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

run.ora

control_files =
(/home/oracle/tpcc_disks/control_001,
/home/oracle/tpcc_disks/control_002)
db_name = tpcc
processes = 600
sessions = 600
transactions = 300
db_files = 600
compatible = 10.1.0.0.0
dml_locks = 500
db_block_size = 2048
aq_tm_processes = 0
max_dump_file_size = 1M
_enable_NUMA_optimization = true
_db_block_numa = 4
db_keep_cache_size = 147500M
db_recycle_cache_size= 40000M
db_cache_size = 42528M
db_8k_cache_size = 500M
db_16k_cache_size = 15360M
log_buffer = 8688608
log_checkpoint_interval = 0
log_checkpoint_timeout = 1700
log_checkpoints_to_alert = true
shared_pool_size = 6500M
java_pool_size = 0
_ksmg_granule_size = 67108864
db_writer_processes = 4
db_block_checking = false
db_block_checksum = false
_check_block_after_checksum = false
_db_writer_max_writes = 512
undo_management = auto
undo_retention = 1
undo_tablespace = undo_1
_imu_pools = 150
_undo_autotune = false
cursor_space_for_time = true
plsql_optimize_level = 2
_cursor_cache_frame_bind_memory = true
replication_dependency_tracking = false
_db_cache_pre_warm = false
fast_start_mttr_target = 0
parallel_max_servers = 0
_two_pass = false
timed_statistics = false
statistics_level = basic
query_rewrite_enabled = false
_collect_undo_stats = false
_db_writer_flush_imu = false
_lightweight_hdrs = true
_smu_debug_mode = 1536
aq_tm_processes = 0
trace_enabled = FALSE

搜罗出用来给Oracle瘦身的参数

_collect_undo_stats=false
timed_statistics = FALSE
_db_cache_pre_warm=FALSE
trace_enabled = FALSE
db_block_checksum = FALSE
trace_enabled = FALSE
statistics_level = basic
pga_aggregate_target = 0
_undo_autotune = false
_check_block_after_checksum = false

很多都适用于超级繁忙的OLTP系统

collect_undo_stats,statistics_level,_undo_autotune,pga_aggregate_target 都是用来减少Oracle维护自己所带来的额外资源消耗。使得系统faster起来。