Error ORA-04030: out of process memory

When i am running a sql file againt one database I am getting the following error .

ORA-20001: Update statement.:ORA-04030: out of process memory when trying to
allocate 475276 bytes (callheap,DARWIN)


Could anybody help me How to fix this error.

Thanks in advance

Is your shared pool large enough?

You could be a hitting a bug that was fixed in 8.1.7.3.

Is this happening in 8i or 9i?

RDBMS version is 8i

and

shared_pool_reserved_size 30000000
shared_pool_size 700000000

Or you can try

if this is a unix machine and you are using a telnet session do

$ ulimit -d unlimited
$ ulimit -s unlimited
$ ulimit -m unlimited
$ ulimit -n unlimited
$ ulimit -c unlimited

and then try....

HTH
Amar

Found that the following event has been set.

event = "10235 trace name context forever, level 1"


Is this causing the problem ?

Quote:

---

Originally posted by ganjisb
Found that the following event has been set.

event = "10235 trace name context forever, level 1"


Is this causing the problem ?

---

This event will check the memory manager internal structures. and generates trace in the UDUMP.

This can be a possible cause as this degrades the performance.

According to metalink

-------------------------------------------------------
This event may be used to try to catch HEAP corruption problems closer to when they occur. Typically level 12 is required to get close to the corruption but this can impact performance too much to be useful.
-------------------------------------------------------

Try removing this parameter and then startup the database and run the querry again.

Regards
Amar