Page 1 of 1
Out of process Memory error
Posted: Tue Mar 31, 2009 9:31 am
by Ragunathan Gunasekaran
I am extracing data from an oracle database and i am getting out of process memory error from oracle.This is a production backup database where i will not find a way to change any settings. Are there some thing that we could do from the Oracle stage in the server
ORA-04030: out of process memory when trying to allocate 249880 bytes (QERHJ hash-joi,kllcqas:kllsltba)
Any help on this please
Re: Out of process Memory error
Posted: Tue Mar 31, 2009 10:41 am
by Pagadrai
Hi,
how many records are you trying to fetch from the table?
Are you getting the same error while executing the query directly?
Can you add some constraints to reduce the record count in source and see if it helps.
Re: Out of process Memory error
Posted: Tue Mar 31, 2009 10:42 am
by Pagadrai
Also ensure your query is not giving any unwanted cartesian product.
Posted: Tue Mar 31, 2009 11:28 am
by chulett
You really need to take that error back to your DBA and see if they can help, perhaps by changing some settings. They may also be able to recommend some "alter session" statements that might help, you can use those in the before-sql tab.
Re: Out of process Memory error
Posted: Wed Aug 26, 2009 4:24 pm
by yserrano
Ragunathan Gunasekaran wrote:I am extracing data from an oracle database and i am getting out of process memory error from oracle.This is a production backup database where i will not find a way to change any settings. Are there some thing that we could do from the Oracle stage in the server
ORA-04030: out of process memory when trying to allocate 249880 bytes (QERHJ hash-joi,kllcqas:kllsltba)
Any help on this please
in this link it explains possible causes and solutions for that error
http://www.dba-oracle.com/t_ora_04030_o ... memory.htm