Re: When to Commit?

edmond wrote:
> I often hear that for long txn, we should commit occasionally rather than
> having a long outstanding txn. But in Expert one-on-one Oracle, the author
> suggest we should commit when required rather than manually inserting commit
> i.e. if our logic is to commit at end of the long txn, so be it (so long as
> our rollback segment is large enough).
>
> What are the considerations behind these 2 approaches?

Use the first approach if you are trying to make your application as slow, unscalable and error-prone as possible. Use the first approach if you consider 1555 to be a lucky number. Use the first approach if you have a DBA so totally out of contact with Oracle that this person is still using rollback segments and refuses to get enough disk space to make it reasonably functional.

In all other cases follow Tom Kyte's advice.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)