Can't allocate memory
417261Aug 30 2004 — edited Aug 30 2004Hello,
I have an question that not really concerne OWB but rather Oracle (adminstration).
This is an error that occurs after running a mapping (in mode SETBASED) that make a insert into a table of a lot of record an also make a lot of calculations for each records.
The solution is to turn the operating mode to ROWBASED and there is no more problem.
That cause the ORA-04030 error : out of process memory when trying to allocate 61464 bytes (koh-kghu sessi,peidxblds:num)
OK, so i remeber that I must change the operating mode, but when a set ROWBASED and a re-run the mapping, this error is still there and i can only run the mapping without problems after one day (+-).
My question is, why ORACLE will not run this mapping immediatly, how can I do to liberate the memory for this mapping?
Remember ORACLE also the name of the mapping? So that when a run the mapping it see that there was already a problem with it and say STOP?
Thanks you,
Sébastien.