Wednesday 20 November 2013

SGA parameter value change in Oracle ASM environment

SQL> show parameter memory

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
memory_max_target                    big integer 272M
memory_target                        big integer 272M
SQL>


$ export ORACLE_HOME=/u01/app/11.2.0/grid
$ export ORACLE_SID=+ASM1

conn as sysasm or sysdba


ALTER SYSTEM SET memory_max_target = 12G scope=spfile sid='*';
ALTER SYSTEM SET memory_target = 12G scope=spfile sid='*';

create pfile='/tmp/pfile_13122012.ora' from spfile;

No comments:

Post a Comment