Re: Commit -> write to data file immediately???

From: Norman Dunbar <ndunbar_at_lynxfinancialsystems.co.uk>
Date: Thu, 29 Mar 2001 15:18:07 +0100
Message-ID: <F43E6BAE5BB5D411A44C00805FBE740D6DF36B@apps.lynx-fsc.co.uk>

Andrew wrote :

>> >>switch, a timeout (every 3 seconds), when the redo log bugger
becomes
>> >>one third full etc. ~~~~~~

>> I agree with your sentiment about the redo log :-)
Oops ! :o)

>> Anyway, the most important misunderstanding above is the 3 second
>> timeout. DBWR will wake up every 3 seconds regardless of anything
>> else, but won't necessarily write anything at that point.

Interesting. My course notes clearly state that there will be a checkpoint 'n' seconds after the last one (but only if LOG_CHECKPOINT_TIMEOUT is set to 'n' seconds. Plus a whole load of other times such as TS being taken offline, instance shutdown etc. Mind you, my notes are O7 and this has probably changed at O8 and O8i - I must get some time to read up :o)

Cheers,
Norman. Received on Thu Mar 29 2001 - 08:18:07 CST