Re: checkpoint not complete
From: Jared Still <jared_at_valleynet.com>
Date: 1996/06/04
Message-ID: <4p1jnv$qup_at_alpine.valleynet.com>#1/1
Date: 1996/06/04
Message-ID: <4p1jnv$qup_at_alpine.valleynet.com>#1/1
chuckh_at_dvol.com (Chuck Hamilton) wrote:
>What happens when the database tries to do a log switch and encounters
>a "Checkpoint no complete" error. Does it wait for the checkpoint to
>complete before switching to the next log? If so does this mean that
>all sessions that're changing the database freeze until the checkpoint
>completes?
<snip>
>--
>Chuck Hamilton
>chuckh_at_dvol.com
Does your init.ora have 'CHECKPOINT_PROCESS = TRUE' in it?
This will create a checkpoint process on DB startup, and relieve the logwriter of doint the checkpoints.
Jared Still, Oracle DBA
RxNet, Division of Value Health
"All opinions are mine, not my employers"
jared_at_valleynet.com
Received on Tue Jun 04 1996 - 00:00:00 CEST