Re: Documentation ???

In article <01bd7fb4$00f2e0c0$6762df81_at_nz6220.nz.unisys.com>, tanyainjac_at_unn.unisys.com says...
> The other possible solution might be: no dirty buffers are written to the
> disk without log buffer being previously flushed to the file.
> But, that contradicts with the fact that DBWR can write dirty buffers if
> the threshold is reached for the dirty buffers or there are no free buffers
> or time-out happens ( found in Oracle Server Concept manual 7.3 (chapter
> 9-7)).

I don't see the contradiction. Could you explain it in more details ?

> It does not say anywhere that writing of dirty buffers on the disk
> causes the flushing of the log buffers.

Well, I read in Oracle Server Concept manual 7.3, page 9-9:

"LGWR writes ... redo buffers when the DBWR process writes modified buffers to disk", which looks to me quite similar to your statement, isn't it ?

Best regards

• Raoul