oracle runc n m,Oracle神奇的一些参数。或者对你有用

这些参数真的是能够让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起来。

转自：

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/42810/viewspace-611382/，如需转载，请注明出处，否则将追究法律责任。