Re: When to Commit?

On 2 Jul 2005 14:22:07 -0700, "Mark D Powell" <Mark.Powell_at_eds.com> wrote:

>Where there are concurrent DML operations against a target table then
>holding a row lock for the duration of a long running update task may
>be very undesirable. It should be acceptable for a batch process to
>wait a few seconds for a row, but even a two second wait may be two
>long for an OLTP user. You have to balance the two competing needs.

Sure, long-running updates ---> outside office hours.

Your approach is the typical 'fighting symptoms approach' That said, there shouldn't be any intermittent commits, EVER. If you need intermittent commit, your design is wrong.

--
Sybrand Bakker, Senior Oracle DBA