Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: fluctuating execution times

Re: fluctuating execution times

From: Steffen Ramlow <s.ramlow_at_gmx.de>
Date: Tue, 8 Jan 2002 19:14:07 +0100
Message-ID: <a1fctm$qanas$1@ID-54600.news.dfncis.de>


ok, i have called System.gc() every 100 and every 1000 prep. statements still the same difference in execution times..

"Steffen Ramlow" <s.ramlow_at_gmx.de> wrote in message news:a1ck80$pdtqd$2_at_ID-54600.news.dfncis.de...
> thx, i ll check this out
>
>
> "Bob Preston" <bobpreston_at_hotmail.com> wrote in message
> news:f2e614a5.0201070811.757d070c_at_posting.google.com...
> > I had a similar problem, and I also looked towards the database access
> > as the culprit. But, then I realized that Java garbage collection
> > times are also a wildcard in the equation (especially on single
> > processor machines). That turned out to be the real culprit.
> >
> > Try putting a System.gc() in your loop.
> >
> > Regards,
> >
> > Bob
>
>
Received on Tue Jan 08 2002 - 12:14:07 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US