Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Need help : degrading performance in record updates
On May 11, 8:39 am, 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.
Any thoughts, as to why this problem of degrading performance could be? And solutions if any?
Thanks in advance :-) Received on Thu May 10 2007 - 22:41:23 CDT