526互联

68.Oracle的内存参数设置

发布时间 2023-11-12 15:53:46作者: 站在巨人的肩上Z

如果服务器是100G内存，那么Oracle的内存参数可以按照如下进行配置:

alter system set sga_max_size=40000M scope=spfile;
alter system set streams_pool_size=1200M scope=spfile;
alter system set large_pool_size=200M scope=spfile;
alter system set pga_aggregate_target=12000M scope=spfile;
alter system set db_cache_size=30000M scope=spfile;
alter system set shared_pool_size=4000M scope=spfile;
alter system set java_pool_size=64m scope=spfile;
alter system set memory_target=0 scope=spfile;
alter system set sga_target=0 scope=spfile;
alter system set log_buffer=31457280 scope=spfile;