Cry about...
Oracle Troubleshooting


ORA-04030: out of process memory


Symptom:

The Oracle error:

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

Cause:

According to Oracle, this error is caused by the private memory available to the process becoming exhausted.

Possible remedies:

  • If the error was generated from RMAN then try reducing the number of channels used, e.g. add:

    Filesperset 20


This page represents one page of many pages of notes I made whilst working with Oracle 7 through to 10i. I now no longer work with Oracle databases, but hope that these notes will continue to be of benefit to others.



About the author: is a dedicated software developer and webmaster. For his day job he develops websites and desktop applications as well as providing IT services. He moonlights as a technical author and consultant.