ORA-04031: unable to allocate 134528 bytes of shared memory ("large pool","unknown object","large po
i am getting frequently ora-04031 error for oracle 11g(11.1.0.7.0) database.
ORA-04031: unable to allocate 134528 bytes of shared memory ("large pool","unknown object","large pool","PX msg pool")
SQL> select * from V$SGASTAT where POOL='shared pool' and name='free memory';
POOL NAME BYTES
------------------------------------------------ -------------------------- ----------
shared pool free memory 185878768
memory_max_target is set to 1gb and memory_target is set to 1 gb,
if we set the above values oracle will automatically allocate and deallocate the memory whenever it needed.
so for this error is i need to increase the memory_max_target value and memory_target value ?