Database 10g on Windows 2008 R2 : ORA-04031 when using automatic memory management
Hi,
I've got the error ORA-04031 : unable to allocate 3896 bytes of shared memory.
I've got that error since I set SGA_TARGET equal to SGA_MAX_SIZE
If I revert to SGA_TARGET=0, then the error no more occurs.
How do you explain that ?
Here are the memory parameters of my database (in Mb) :
Buffer Cache Size 108
Java Pool Size 48
Large Pool Size 8
Shared Pool Size 204
log_buffer 6
pga_aggregate_target 50
sga_max_size 396
sga_target 0
Rgds,
Frederic