Thursday, September 18, 2008

ora-04031-unable to allocate 8196 bytes of shared memory

Message:

ORA-04031: unable to allocate string bytes of shared memory ("string" ,"string" ,"string" ,"string")

Cause:

More shared memory is needed than was allocated in the shared pool.

Action:

If the shared pool is out of memory, either use the dbms_shared_pool package to pin large packages, reduce your use of shared memory, or increase the amount of available shared memory by increasing the value of the INIT.ORA parameters "shared_pool_reserved_size" and "shared_pool_size". If the large pool is out of memory, increase the INIT.ORA parameter "large_pool_size".

No comments: