massive update tuning

i got an external application to tune on our oracle 8.0.3 database on digital unix.

the operation it lacks performance against the proprietaray version of its database is
a bunch of 1000 updates like this:

update dt101 set di1=:bind1 set di2=:bind2 .... where di99=:bind99 and di999=:bind999;
commit;

there are indexes in di99 and di999, this seems to be the key in this table.

under runtime it behaves like this: first it executes quite fast, but slows down at every new update call.

how can i
a) rewrite this particular statement
b) do some lower level tuning on the database parameters

thanks in advance!

  <ad> Received on Sat Nov 07 1998 - 18:53:37 CET