Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DWBR and dirty buffers
Jonathan Lewis apparently said,on my timestamp of 25/02/2005 6:03 PM:
>
> Blocks are not really 'flushed' by a checkpoint, only
> cleaned. So, in theory, you should see all the XCUR
> stay in memory and turn to CR
Nope, not much happening with those here.
> You may find that a few blocks seem to stay as
> xcur - check the objd (data object id) for these,
> it will probably be about 4 billion - meaning it's
> from a rollback segment. There's always a little
> background activity going on which means that
> a few more blocks will be dirtied even as the
> checkpoint is running.
Ah yes, this could well explain it. I'll monitor for this and see if it is consistent.
-- Cheers Nuno Souto in sunny Sydney, Australia wizofoz2k_at_yahoo.com.au.nospamReceived on Fri Feb 25 2005 - 18:05:03 CST