Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsWhite Papers
Discussion GroupsFirst AidDatabasesJavaBeansGUIJava 3DVirtual MachineCORBASecurityToolsGeneral
Java DirectoryOpen Source ProjectsSample Book ChaptersUser GroupsWeb Resources
Related Topics
Databases.NETMore Topics ...

Java Forum / Databases / May 2007

Tip: Looking for answers? Try searching our database.

Need help : degrading performance in record updates

Thread view: 
AkshayAOI@gmail.com - 11 May 2007 04:43 GMT
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 :-)
tzvika.barenholz@gmail.com - 13 May 2007 14:49 GMT
On May 11, 6:43 am, Akshay...@gmail.com wrote:
> We are facing some problem in our batch application.
> This java based application is reading a file with 25 lakh records
[quoted text clipped - 23 lines]
>
> 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


Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.