Wednesday 1 February 2012

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

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:

Post a Comment