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起来。

转自：http://www.chinasolaris.com/viewthread.php?tid=1024

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

转载于:http://blog.itpub.net/42810/viewspace-611382/