[转载]在32 bit windows设置大于1.7G SGA

最新推荐文章于 2024-06-26 23:53:45 发布

转载最新推荐文章于 2024-06-26 23:53:45 发布 · 128 阅读

本文介绍了一组用于优化Oracle数据库性能的内存参数配置方法，包括调整SGA大小、启用作业调度和日志挖掘等功能。

rem _db_block_lru_latches=cpu_count*2*8
alter system set "_db_block_lru_latches"=64 scope=spfile;
rem 32bit os 1.7G以上SGA必须设置USE_INDIRECT_DATA_BUFFERS为真
alter system set USE_INDIRECT_DATA_BUFFERS=true scope=spfile;
rem 去掉sga_max_size和db_cache_size参数，否则不支持32bit大容量sga
alter system reset sga_max_size scope=spfile sid='*';
alter system reset db_cache_size scope=spfile sid='*';
rem 设置该参数可以确保启动时内存不溢出
alter system set lock_sga=false scope=spfile;
rem 800MB
alter system set shared_pool_size=838860800 scope=spfile;
rem 358400*8192=2.8G db_cache_size
alter system set db_block_buffers=358400 scope=spfile;
rem 100MB
alter system set large_pool_size=104857600 scope=spfile;
rem 100MB
alter system set java_pool_size=146800640 scope=spfile;
rem 3G
alter system set pga_aggregate_target=3221225472 scope=spfile;
alter system set open_cursors=700 scope=spfile;
alter system set cursor_sharing=similar scope=spfile;
rem 启用作业调度
alter system set job_queue_processes=3 scope=spfile;
rem 启用日志挖掘
alter system set logmnr_max_persistent_sessions=3 scope=spfile;
rem 3M
alter system set log_buffer=3145728 scope=spfile;
rem 归档日志模式
alter system set log_archive_dest='e:archivelogchs'
alter system set log_archive_start=TRUE
--注册表HKEY_LOCAL_MACHINESOFTWAREOracleHome0AWE_WINDOW_MEMORY=274572800(_db_block_lru_latches*4096*db_block_size+5MB)
--Windows 2003启动加/PAE参数