Hi
I am a bit rusty in terms of oracle memory settings and would be grateful of some help.
I have a few databases on a server and am encountering memory issues with one database that is crashing:
ORA-04031: unable to allocate
3896 bytes of shared memory ("shared pool","Select object_name
from sys....","sga
heap(2,0)","kglsim object batch")
I have doubled memory target from 2 gigs to 4 gigs but when I query the memory settings I see SGA size is the same as before even after restart. I presumed when you set memory_max_target and memory_target oracle would automatically take care of the other settings and increase them but they seem to be the same as before, the SGA total size is the same anyway.
SQL> SELECT sum(value)/1024/1024/1024 "TOTAL SGA (MB)" FROM v$sga;
TOTAL SGA (MB)
--------------
1.75780106
SQL> select sum(pga_max_mem)/1024/1024 "TOTAL MAX PGA (MB)" from v$process;
TOTAL MAX PGA (MB)
------------------
430.687513
SQL> show parameter memory;
memory_max_target big integer 4G
memory_target big integer 4G
Thanks in advance