Re: Question on REDO & SCN

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 25 Nov 2005 11:36:25 +0000 (UTC)
Message-ID: <dm6svp$svs$1@nwrdmz01.dmz.ncs.ea.ibs-infra.bt.com>

"Pradeep" <agarwalp_at_eeism.com> wrote in message news:1132907250.204580.84100_at_o13g2000cwo.googlegroups.com...
> Is it because of this redo generated after each commit that we should
> not commit in a loop, rather commit after the transaction
>

The first reason for committing after
the transaction is data correctness.

The second reason for committing
after the transaction is for restartability.

The third reason committing after the
transaction - and especially for not
committing inside the loop - is that
the various overheads from a large
number of very small transactions
(loop commits being the prime example)
can be dramatic.

-- 
Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html
Cost Based Oracle: Fundamentals

http://www.jlcomp.demon.co.uk/appearances.html
Public Appearances - schedule updated 4th Nov 2005

Received on Fri Nov 25 2005 - 05:36:25 CST