Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: DWBR and dirty buffers

Re: DWBR and dirty buffers

From: Noons <wizofoz2k_at_yahoo.com.au>
Date: Sat, 26 Feb 2005 11:05:03 +1100
Message-ID: <421fbd0f$0$21871$5a62ac22@per-qv1-newsreader-01.iinet.net.au>


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.nospam
Received on Fri Feb 25 2005 - 18:05:03 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US