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

From: Richard Foote <richard.foote_at_bigpond.com>
Date: 14 Jul 2003 20:28:52 -0700
Message-ID: <69f6c1c8.0307141928.d538656@posting.google.com>

spendius_at_muchomail.com (Spendius) wrote in message news:<aba30b75.0307140556.6a8baf93_at_posting.google.com>...
> 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.

Hi Spendius,

The "checkpoint" writes all associated dirty buffers to the O/S (performed by DBWRs) and marks the associated data file headers (performed by CKPT).

It's the "CKPT process" that only writes to the datafile headers (and control files).

Possibly the cause for the confusion ?

Cheers

Richard Received on Mon Jul 14 2003 - 22:28:52 CDT