ORA-04030: out of process memory when trying to allocate 123404 bytes
685758Jan 11 2011 — edited Jan 11 2011Hi All,
I was running a script which contains plsql code as in below senerio.This is stucking somewhere so that I am not able to see log also.for around 65 thousand records script was running fine but as records are increasing its stucking.
I am having senerio like below
SET BUFFER 1000000
SET SERVEROUTPUT ON
spool Log_file.log
declare
begin
begin Loop1 -- more than 1 lac records
begin Loop2 -- more than 50 records for each loop1's record,total more than 5 lac records in loop2.
begin Loop3 -- more than 50 records for each loop1's record,total more than 5 lac records in loop3.
end Loop3;
end Loop2;
end Loop1;
End;
/
spool off
exit;
my script was running since a long time so i used collection for insertion in all loops.but now I am getting error
"ORA-04030: out of process memory when trying to allocate 123404 bytes (QERHJ hash-joi,kllcqas:kllsltba)"
kindly help me to fix this issue.kindly provide me why this error is coming & how to resolve this.
rgds,
pc