Cry about...
Oracle Troubleshooting

ORA-04030: out of process memory


The Oracle error:

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


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.