Re: DWBR and dirty buffers

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 24 Feb 2005 14:05:30 +0000 (UTC)
Message-ID: <cvkmva$s9$1@sparta.btinternet.com>

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.

-- 
Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/seminar.html
Public Appearances - schedule updated Jan 21st 2005






<wagen123_at_yahoo.com> wrote in message 
news:1109212005.567929.44620_at_g14g2000cwa.googlegroups.com...


> posting again...

>

> It appears that dirty buffers for a specific object exists in the

> buffer cache even after

> - switching through all online redo logfiles (twice)

> - alter system checkpoint

> - select * from t1

>

Received on Thu Feb 24 2005 - 08:05:30 CST