Optimizing commit intervals for efficiency

From: Jarl Petter Kvalsvik <Jarl-Petter.Kvalsvik_at_telenor.com>
Date: Fri, 3 Sep 1999 14:02:56 +0200
Message-ID: <7qodd1$64a@info.telenor.no>

Hi!

Does anyone have experiences in tuning commit intervals in a typical batch application?

Say that you have a batch of 100000 transactions and every transaction on average does 10 updates. Are there any formulas/rules of thumb of how many transactions should be processed between each commit? Or is this something you have to find out the hard way? Or is the commit overhead in Oracle ignorable so that you would commit every transaction?

Thank you for wasting time on this.
- Jarl Petter Received on Fri Sep 03 1999 - 07:02:56 CDT