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 -> Progressive slow Insert and Update

Progressive slow Insert and Update

From: Joe <hidden_at_address.no>
Date: Wed, 11 Oct 2006 17:17:03 +0200
Message-ID: <egj1ql$68b$2@bat-news01.banetele.basefarm.net>


I have a (for me) strange situation, where each insert and update on a specific table gets slower and slower. The first insert takes milliseconds but like the 10th insert takes already 1 min. Performance of selects from this table is constant . There are lots of other sqls against other tables but these have constant response times. Restarting the user session resets the times.

There should be nothing special about this table so I need some help on where I should start looking for the cause.

Thanks,
Joe Received on Wed Oct 11 2006 - 10:17:03 CDT

Original text of this message

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