alter system set sga_max_size=24G scope=spfile;
alter system set sga_target=24G scope=spfile;
alter system set pga_aggregate_target=5G scope=spfile;
alter system set sga_target=24G scope=spfile;
alter system set pga_aggregate_target=5G scope=spfile;
alter system set sga_max_size=20G scope=spfile;
alter system set sga_target=20G scope=spfile;
alter system set pga_aggregate_target=5G scope=spfile;
shutdown immediate;
startup;
上面是正常情况,也有可能你装的是32位的oracle,sga只能用到1.7G,呵.
也有可能上面调整,但报错了,可能是你的/etc/sysctl.conf 下的文件kernel.shmall设置的太小
shutdown immediate;
startup