Out of process Memory error

[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

[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.

[Pagadrai]

Also ensure your query is not giving any unwanted cartesian product.

[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.

[yserrano]

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