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