Out Of Memory Process
Hi Guys..
Oracle Version : 9.2.0.4
OS : Win NT
In these recent days we are getting the error ORA-04030: out of process memory when trying to allocate 1008128 bytes (hash-join subh,kllcqas:kllsltba) very frequently. I did RTFM regarding this error many a times, but i still cant find out the root cause, as i always see the memory usage of the process oracle.exe never exceeded 1.5 GB.. When the memory limit on Win NT is 2GB why do i see this error??
Rgds
Abhay.
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"