Database Error Messages

More shared memory was needed than was available.

If using one of the initialization parameters SGA_TARGET, MEMORY_SIZE, or MEMORY_TARGET, increase the value of that parameter. If it is not feasible to increase the parameter, then reduce the value of DB_CACHE_SIZE (if set). If you are not using SGA_TARGET, MEMORY_SIZE, or MEMORY_TARGET, increase the size of the pool that is out of memory. For example, increase SHARED_POOL_SIZE for the shared pool or INMEMORY_SIZE for an IMC heap. If it's an invalid request issue, contact Oracle support.

More shared memory is needed than was allocated in the shared pool or Streams pool.

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.

More shared memory is needed than was allocated in the shared pool or Streams pool.

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