Re: Does an ALTER SYSTEM CHKPOINT write all dirty buffers to datafiles ?

It writes the dirty buffers to disk. It doesn't make sense that it only updates the SCN. The SCN in the datafile header needs to be greater than or equal to the largest SCN of modified data in the datafile's blocks. Why make the SCN a higher number and then update it later with lower SCN dirty blocks?

HTH,
Brian

Spendius wrote:
>
> Does this command really ascertain that *all* modified buffers
> will be written out to disk ??
>
> I'd just like to make sure (the doc. is not very clear about
> it, and I found different answers to this question -according to
> some it does write all dirty buffers, according to other people
> it only updates the SCN in the datafiles' headers...-).
>
> Thanks.
> Spendius

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"