Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Garbage collection not happening?
Jacy Grannis schrieb:
> I have a very curious problem that I can not figure out a good cause
> for. Here's the story: we are using iPlanet 6.0sp2 on jdk1.3.1, and
> Oracle 8.1.7. There is an option on our site where a user can click a
> link and download a .csv file containing a lot of information from the
> db. This .csv file can be as much as 6MB big. It has, at most, about
> 17,000 rows in it. Each row has ~60 columns. The exact numbers
> depend on options the user has selected before choosing to do the
> download. If the user selects the option that would pull down the
> entire data-set, this invariably causes the machine to run out of
> memory. An OutOfMemoryError is thrown, and the server restarts
> itself. It seems to run out of memory in the loop where it is pulling
> the data out of the result set. However, I assure you it is doing
> nothing unusual in that loop.
>
Hmm are you sure, that the full set of data fits into the heap?
Did you try giving the JVM more memory when starting it? (-Xmx option) We are processing large amount of data as well (in memory) and we usually need to start the JVM with something like -Xmx256m (because the default Heap Size is 96MB)
Thomas Received on Wed Sep 04 2002 - 14:47:04 CDT