Re: Updates synced to disc???

In article <785176238snz_at_toronto.demon.co.uk>

           John_at_toronto.demon.co.uk "John Thomas" writes:

> >In article <Cz9qIK.Iuq_at_ottnews.shl.com> you write:
> >
> >> I have read that Oracle writes are "sync'ed" to disk whenever an insert
> >> or update occurs. This to ensure data integrity.
> >>
> >
> >Surely not? DBWR writes updates to disc when a "checkpoint" occurs.
> >Data integrity is ensured by storing before-image and after-image in
> >rollback segments. Writing to sequential rollback-logs
> >SHOULD be much faster than writing the row changes.
> >
> >... sorry if this is wrong... the views of a non-DBA

The writes to the rb segs are sync()ed.

-- 
Paul Beardsell                          SAM Business Systems Ltd
~~~~~~~~~~~~~~                          21 Finn House, Bevenden St,
pbeardsell_at_cix.compulink.co.uk          London, N1-6BN, UK.
psb_at_sambusys.demon.co.uk                (+44 or 0)71 608-2391