Using AMM, sga throwing error of "unable to allocate 32 bytes of shared memory"
I am using Automatic Memory Management. I have set the parameters as :-
memory_max_target big integer 10G
memory_target big integer 9G
sga_max_size big integer 1G
sga_target big integer 0
sga_max_size is not set to null. If i am not wrong it takes it as a minimum value of sga and can expand upto memroy_target.When i check from v$sgainfo it shows
SQL> select * from v$sgainfo;
NAME BYTES RES
-------------------- ---------- ---
Fixed SGA Size 2235000 No
Redo Buffers 14024704 No
Buffer Cache Size 167772160 Yes
Shared Pool Size 834666496 Yes
Large Pool Size 4194304 Yes
Java Pool Size 37748736 Yes