ORA-04031 unable to allocate 4200 bytes of shared memory


Error Message:

OCIStmtExecute: ORA-04031: unable to allocate 4200 bytes of shared memory (“shared pool”,”unknown object”,”sga heap”,”state objects”)

Cause:

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

Analysis:

Bug on Oracle 8.1.7.2

Solution:

metalink suggest to set the parameter _db_handles_cached=0

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”.

Links:

http://www.orafaq.com/maillist/oracle-l/2005/03/03/0169.htm

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s