Oracle RAC内存参数调整

rjyang

由于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修改完成。

注意红色字体部分。