"Howard J. Rogers" <dba_at_hjrdba.com> wrote in message
news:affpam$6m5$1_at_lust.ihug.co.nz...
> > 2.. INSERT would need minimal (rowid + overhead per row) of Rollback.
>
> Incorrect. Incorrect in the sense that 'minimal' means different things to
> different people. An insert's rollback is pretty small compared with a
> delete, that's for sure. But it's not nothing, and not even close to being
> practically nothing.
And also the original poster seems to imagine that rollback io is done on a
per row changed rather than a per block changed basis.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
Received on Thu Jun 27 2002 - 15:51:55 CDT
