04030-04039: System Memory Messages

This section lists messages generated by an Oracle Server when the operating system cannot allocate sufficient memory during an Oracle session.

ORA-04030: out of process memory when trying to allocate num bytes str,str

Cause: Operating system process private memory has been exhausted.

Action: See the database administrator or operating system administrator to increase process memory quota. There may be a bug in the application that causes excessive allocations of process memory space.

ORA-04031: unable to allocate num bytes of shared memory num, num, num

Cause: More shared memory is needed than was allocated in the operating system process. SGA private memory has been exhausted.

Action: 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 set for the SHARED_POOL_SIZE initialization parameter.

---