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 or Streams 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 initialization parameters SHARED_POOL_RESERVED_SIZE and SHARED_POOL_SIZE. If the large pool is out of memory, increase the initialization parameter LARGE_POOL_SIZE. If the error is issued from an Oracle Streams or XStream process, increase the initialization parameter STREAMS_POOL_SIZE or increase the capture or apply parameter MAX_SGA_SIZE.