Re: DWBR and dirty buffers

From: Noons <wizofoz2k_at_yahoo.com.au>
Date: 23 Feb 2005 23:28:50 -0800
Message-ID: <1109230130.623602.185560@l41g2000cwc.googlegroups.com>

wagen123_at_yahoo.com wrote:
> Why are the dirty blocks not flushed to disk?
>

Maybe it's just not meant to?
See this:

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

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

N     145996
Y      10160

Elapsed: 00:00:01.00
Purr...>alter system switch logfile;

System altered.

Elapsed: 00:00:00.00
Purr...>select dirty,count(1) from v$bh group by dirty; Press Return to continue...

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

N     145996
Y      10160

Elapsed: 00:00:00.08
Purr...> Received on Thu Feb 24 2005 - 01:28:50 CST