Any help on this pleaseORA-04030: out of process memory when trying to allocate 249880 bytes (QERHJ hash-joi,kllcqas:kllsltba)
Out of process Memory error
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 247
- Joined: Mon Jan 22, 2007 11:33 pm
Out of process Memory error
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
Regards
Ragu
Ragu
Re: Out of process Memory error
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.
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
Also ensure your query is not giving any unwanted cartesian product.
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Re: Out of process Memory error
in this link it explains possible causes and solutions for that errorRagunathan 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
Any help on this pleaseORA-04030: out of process memory when trying to allocate 249880 bytes (QERHJ hash-joi,kllcqas:kllsltba)
http://www.dba-oracle.com/t_ora_04030_o ... memory.htm