www.oradev.com
  Database   Sql   Functions   Packages   Performance   Books   Oracle   Other   About   XML   ORA-messages
  ORA-04031

Common error messages

TNS connection closed
IO error writing block
Resource busy
Invalid character
Invalid datatype
Syntax error
Looping chain synonyms
Resolve connect identifier
number too large for buffer
All error messages



  OraDev.com

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

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". Fragmentation of shared pool memory can also be the cause for ORA-04031. Because of fragmentation there can not be sufficient contiguous free memory available in the shared pool.