rac 修改节点SGA
时间:2011-04-08 来源:penglele2009
1.修改第一个节点:
alter system set sga_max_size=2G sid="rac1 "scope=spfile;
alter system set sga_target=2G sid="rac1 "scope=spfile;
shutdown immediate
startup
2.当第一个节点启动后,修改第2个节点:
alter system set sga_max_size=2G sid = "rac2 "scope=spfile;
alter system set sga_target=2G sid = "rac2 "scope=spfile;
shutdown immediate
startup
rac
alter system set sga_max_size=2G sid="rac1 "scope=spfile;
alter system set sga_target=2G sid="rac1 "scope=spfile;
shutdown immediate
startup
2.当第一个节点启动后,修改第2个节点:
alter system set sga_max_size=2G sid = "rac2 "scope=spfile;
alter system set sga_target=2G sid = "rac2 "scope=spfile;
shutdown immediate
startup
rac
相关阅读 更多 +