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
相关阅读 更多 +
