Hi

Using oracle 8.1.7.4 on a Windows 2000 server platform, every 20 or so days
when the DB has been up users start receiving this message

11:31:56.985 Program ORA-04030: out of process memory when trying to
allocate 664064 bytes (cursor work he,kllcqas:kllsltba)

Any ideas how I can prevent this, been told to bounce the database on a
weekly basis but surely
this is not necessary

Regards

Mill

David Meadows wrote:
It looks like you have a memory leakage in some program. ORA-4030 means
oracle user process could not get a chank of memory from the heap, to be
exact, OS could not find free memory (the size - RAM + swap -
system-programs)for user process. Decreasing shared pool and buffer
might help, but this solution is a temporary one. The best way is to
find the process what eats free memory.