Oracle error
ORA-04030
ORA-04030: out of process memory when trying to allocate %s bytes (%s,%s)
What usually causes it
A server process couldn't get more private memory from the operating system: OS limits, a real memory shortage, or a runaway PL/SQL collection.
What to check first
The trace file shows which heap grew. Check OS memory and ulimits, and the session's PGA use.
Scripts that help
- SGA components and PGA usageCurrent size of each SGA pool, then PGA target against what's actually allocated. PGA allocated well above target points at sort- or hash-heavy…
- Alert log errors in the last 24 hoursORA- and TNS- errors plus checkpoint warnings from the alert log, read through SQL. It can be slow when the alert log is very large.