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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Need help : degrading performance in record updates

Re: Need help : degrading performance in record updates

From: EscVector <Junk_at_webthere.com>
Date: 11 May 2007 19:49:57 -0700
Message-ID: <1178938197.333629.35570@q75g2000hsh.googlegroups.com>


On May 10, 11:39 pm, Akshay..._at_gmail.com wrote:
> We are facing some problem in our batch application.
> This java based application is reading a file with 25 lakh records and
> updating in Oracle DB.
> The batch is commited after each 300 records.
> We are taking a time stamp after each 10000 records.
>
> What we have observed is, initial it was taking some 3-4 seconds to
> update 10000 records.
> The time required is increasing progressively.
> After 12 Lakh records, now it is taking almost 10+ mins to update
> 10000 records.
>
> I have failed to pin down a problem, for such continuously degrading
> performance.
> This is important for us because, we have such 16 files to upload. And
> this upload is just data preparation for the analysis that we need to
> perform on one bug that is observed on production.
>
> I think, Re-do logsize of Oracle should not be a problem since we are
> committing every 300 records.

10046 trace and profile it. You won't need to guess. Borrow or by this book: http://www.bookpool.com/sm/059600527X. It tells you how to not guess.
Use bulk processing where possible.... Received on Fri May 11 2007 - 21:49:57 CDT

Original text of this message

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