Re: COMMIT frequency

On Mon, 16 Mar 1998 11:48:25 -0500, Tad Davis <davist_at_isc.upenn.edu> wrote:

>We have a number of PL/SQL batch routines that perform various updates.
>The question has arisen from time to time about how often to do
>commits. Typically the updates are very simple one-row-at-a-time
>procedures, no complex transaction or distributed processing to worry
>about, no special rollback considerations. (Our updates are written in
>such a way that if a job fails halfway through, it can simply be
>restarted.)
>

Could you please describe the method you use in order to let a job be restarted if it fails halfway through (resuming at the point where it left)?

Nuno Guerreiro Received on Wed Mar 18 1998 - 00:00:00 CST