Oracle DBA, How To, Error, Cause and Action

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.