Re: Article about supposed "murky" future for Oracle

>
> is it safe: 100%.
>
> Does it have any effect in recover: no. Why shud it. All it does it to
> clear the dirty pages fast.
>

Admittedly it's a (probably very rare) corner case, but what happens if

1. Manual checkpoint starts
2. Users dirty pages, some of which have been flushed by manual checkpoint, some of which haven't
3. Logs go above high water mark, forcing an engine checkpoint
4. Engine checkpoint starts

Potential race condition ? Received on Thu Apr 01 2004 - 10:13:23 CST