Re: DWBR and dirty buffers

Jonathan Lewis wrote:
> Check the status of the dirty blocks.
> You may find that they are all CR.
>
> When a dirty current block is cloned to create
> a CR block, there seem to be cases where the
> dirty bit is carried to the CR block - and CR blocks
> are never written, so the bit never changes.
>

Interesting.
Check this from my RAC db, 9ir2:

Purr...>select dirty,status,count(1)
  2 from v$bh
  3 group by dirty,status;
Press Return to continue...

D STATU COUNT(1)
- ----- ----------

N cr            73
N free           1
N xcur      145846
Y cr            63
Y xcur       10173

Elapsed: 00:00:01.00

those dirty blocks don't get cleaned in
a switch logfile. Received on Thu Feb 24 2005 - 21:01:11 CST