Re: Fast object checkpoint

From: Mladen Gogala <mgogala_at_verizon.net>
Date: Sat, 23 Sep 2006 15:04:21 -0400
Message-id: <1159038261l.4887l.0l@medo.noip.com>

On 09/23/2006 02:21:21 PM, Jonathan Lewis wrote:

>
> I don't understand why you think that writing the
> dirty blocks from one object is likely to cause
> more problems than writing the dirty blocks from
> every object in the tablespace that holds the one
> object that needs to be written.
>

Jonathan, the session that motivated me to start investigating spent significant time waiting for the "KO" enqueue. V$LOCK_TYPE tells me that this is "Multiple Object Checkpoint" and that it "Coordinates checkpointing of multiple objects". I haven't had such problems with the usual checkpoints, which were well described in the documentation. The mere fact that I noticed waiting for the checkpoint means that there is a problem. Principle sounds right, on paper, but whoever has written anything more complex then printf("%s\n","Hello World"); knows that the devil lies in the details. I believe that the problem is in the sloppy coding and Elbonian project management. As Oracle 10.2 is the first version having such a nice feature that I had discovered yesterday, I'm inclined to turn it off until it's ready for the prime time.

-- 
Mladen Gogala
http://www.mgogala.com

--
http://www.freelists.org/webpage/oracle-l

Received on Sat Sep 23 2006 - 14:04:21 CDT