Out of Process Memory error

[THoey]

A co-worker is recieving the following error when trying to run a stored procedure on a Unix box:

ORA-04030 out of process memory when trying to allocate num bytes str,str

Oracle help gives me the following cause and action:

Cause: Operating system process private memory has been exhausted.

Action: See the database administrator or operating system administrator to increase process memory quota. There may be a bug in the application that causes excessive allocations of process memory space.

Any ideas what this means? They asked me and it seems like it is something in Unix that is not configured correctly.

Thanks in advance...
Terry M. Hoey

 

[carp]

The cause may depend a lot on the type of box, Unix version, and Oracle version. Metalink shows a lot of different possibilities; your best be is probably to contact Oracle support for a specific situation.

It may very well be a bug/memory leak.