Re: Progressive slow Insert and Update

On Oct 11, 11:17 am, "Joe" <hid..._at_address.no> wrote:
> 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

Joe, try running a trace with wait events on the insert process. This should show you what the waits are and where the wait time is being spent.

HTH -- Mark D Powell -- Received on Wed Oct 11 2006 - 12:49:41 CDT