Database Memory & 4030/4031 (MOSC)

MOSC Banner

ORA-04031: unable to allocate 134528 bytes of shared memory ("large pool","unknown object","large po

edited Jun 21, 2018 1:28PM in Database Memory & 4030/4031 (MOSC) 5 commentsAnswered
 Hi all,

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 ?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center