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 -> Inserting performance issue

Inserting performance issue

From: don <dzhang2k_at_yahoo.com>
Date: 23 Sep 2003 12:11:50 -0700
Message-ID: <6dce23d4.0309231111.5aa01767@posting.google.com> 





Hi



I have several batch jobs to insert a lot of data to DB, they run
hours.


The rate of insert varies, at begining it is slow, then it speeds up,
sometimes dramatically, then later it slows down again.
Is it because DB Writer wait till checkpoint to write, or what is
exactly explanation?



Thanks,


Don
Received on Tue Sep 23 2003 - 14:11:50 CDT












Original text of this message













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