由于RAC的结构相对比较复杂,内存参数的调整相对也比较复杂。
首先以Oracle用户登录节点1:
[oracle@rac1 ~]$ sqlplus /nolog
SQL>conn sys/yourpasswd@instance1 as sysdba
SQL>alter system set shared_pool_size=1000M scope=spfile;
SQL>alter system set large_pool_size=200M scope=spfile;
SQL>alter system set java_pool_size=200M scope=spfile;
SQL>alter system set db_cache_size=18000M scope=spfile;
SQL>shutdown immediate
SQL>startup
节点1修改完成。
然后以Oracle用户登录节点2:
[oracle@rac2 ~]$ sqlplus /nolog
SQL>conn sys/yourpasswd@instance2 as sysdba
SQL>alter system set shared_pool_size=1000M scope=spfile;
SQL>alter system set large_pool_size=200M scope=spfile;
SQL>alter system set java_pool_size=200M scope=spfile;
SQL>alter system set db_cache_size=18000M scope=spfile;
SQL>shutdown immediate
SQL>startup
节点2修改完成。
注意红色字体部分。
阅读(3599) | 评论(0) | 转发(0) |