Updates synced to disc???
From: John Thomas <John_at_toronto.demon.co.uk>
Date: Fri, 18 Nov 1994 16:30:38 +0000
Message-ID: <785176238snz_at_toronto.demon.co.uk>
Date: Fri, 18 Nov 1994 16:30:38 +0000
Message-ID: <785176238snz_at_toronto.demon.co.uk>
>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
>
>--
>John Thomas, Oracle Team Leader E-Mail: John_at_toronto.demon.co.uk
>The shorter the sig, the smarter the author. Tel: 0181 944 9858
Received on Fri Nov 18 1994 - 17:30:38 CET