Re: Need help : degrading performance in record updates
- From: "tzvika.barenholz@xxxxxxxxx" <tzvika.barenholz@xxxxxxxxx>
- Date: 13 May 2007 06:49:20 -0700
On May 11, 6:43 am, Akshay...@xxxxxxxxx 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 :-)
(to quote the mighty Celko) please post the DDL of the table you are
updating, to make helping you easier. also, you shouldn't assume that
everyone in the world know that lakh=100,000 :-)
my best guess would be that the column you are updating is indexed,
and that the index is deteriorating. as an experiment, you could try
to drop the index(or indices) and see if the problem goes away.
if this is the problem, rebuilding the index (I'm not sure how this is
actually done in orcl) will do the trick, but may be just as
expensive. i'd try to live without the index.
if it's not the index it's bound to be disk-level fragmentation - so
maybe try to pre-allocate a lot of space on the tablespace etc.
good luck
T
.
- References:
- Need help : degrading performance in record updates
- From: AkshayAOI
- Need help : degrading performance in record updates
- Prev by Date: Re: approach to upgrading
- Next by Date: How to tell the HOST and PORT of oracle DB through SID?
- Previous by thread: Need help : degrading performance in record updates
- Next by thread: oo-relational jdbc mapping approach
- Index(es):
Relevant Pages
|
|
