[轉載]在32 bit windows設定大於1.7G 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引數