SQL> ALTER SYSTEM SET SGA_TARGET=8G scope=spfile;
System altered.
SQL> alter system set SGA_MAX_SIZE=8G scope=spfile;
System altered.
SQL> startup nomount
ORA-01078: failure in processing system parameters
ORA-00838: Specified value of MEMORY_TARGET is too small, needs to be at least 7184M
SQL> exit
SQL> alter system set memory_target=8208M scope=spfile;
System altered.
SQL> alter system set memory_max_target=8208M scope=spfile;
System altered.
SQL> startup nomount
ORA-00845: MEMORY_TARGET not supported on this system
SQL> exit
Disconnected
$ df -h |grep /dev/shm
Filesystem Size Used Avail Use% Mounted on
tmpfs 7.4G 176M 7.2G 3% /dev/shm
FIX:-
$ mount -o remount,size=9G /dev/shm
$ df -h |grep /dev/shm
Filesystem Size Used Avail Use% Mounted on
tmpfs 9.0G 8.2G 851M 91% /dev/shm
SQL> show parameter sga;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 8G
sga_target big integer 8G
No comments:
Post a Comment