Search notes:

ORA-04030: out of process memory when trying to allocate … bytes

The ORA-04030 error indicates that a process was unable to allocate more memory from the operating system for use in the PGA.
Compare this error message with ORA-04031: unable to allocate … bytes of shared memory which indicates a similar problem ni the SGA.

TODO

Setting 4030 event

alter session set events '4030 trace name heapdump level 25';

Init parameters

The sort_area_size init parameter can haave an impact on memory consumption

See also

Other Oracle error messages

Index