ORA-04031
out of shared memory in heap_name
- heap_name: The top heap name.
Cause
More shared memory was needed than was available.
Action
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.