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;
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