Monday, January 23, 2012

ORA-04031: unable to allocate N bytes of shared memory

This error can we fixed by increasing shared pool memory.

Or you can flush your shared pool memory ,If the size is already High

SQL>alter system flush shared_pool;

You can increase shared pool size(shared_pool_size) using parameter file(INIT.ORA)

Or you can dynamically increase your size by

SQL>ALTER SYSTEM SET SHARED_POOL_SIZE=1200M SCOPE=BOTH;

No comments:

Post a Comment