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