日期:2014-05-16  浏览次数:20445 次

oracle11g rac asm 实例内存修改

 

ASM实例内存修改

 

 

memory_max_target(它为静态参数,修改完成后需要重启实例)

 

memory_target(它为动态参数,不需要重启实例)

 

SQL> select name,issys_modifiable from v$parameter   where name='memory_max_target';

  

NAME                                                                             ISSYS_MOD

-------------------------------------------- ---------

memory_max_target                                                                FALSE

 

 

SQL> select name,issys_modifiable from v$parameter where name='memory_target';

 

NAME                                                                             ISSYS_MOD

-------------------------------------------- ---------

memory_target                                                                    IMMEDIATE