Re: "Checkpoint not complete" message in alert.log file

Sheilah,

Thanks for the tip. v$sysstat is a very interesting view of the system. I tried making the redo logs larger (originally 3 x 500K, now 5 x 2M) and 'redo log space requests' went from 2483 down to 28.

Also, thanks to all the other kind people (and there are many) who have posted solutions to my problem.

Regards,

Ken

> Ken Nichols wrote:
 

> > I see this message from time to time in alert_RCM.log (our database name
> > is 'RCM'). Does the "Checkpoint not complete" message mean that
> > anything is wrong? I have not been able to find a reference to this
> > message anywhere in the docs.

Sheilah Scheurich wrote:
>
>What this means is that your redo logs are most likely too small or too
> few. More often than not, it is the first. If you will notice, this
> error usually occurs when the database is in a high state of inserts,
> updates or deletes. This error means that all of the redo logs are
> writing and when trying to access the next in the order, it is still
> writing. I refer to this as spinning. Check in your v$sysstat
> parameter for redo log space requests. You will most likely find that
> this is a non-zero value, possibly quite high. Increase the size of
> your redo logs, and this should alleviate your problem.
>
> -Sheilah Scheurich
> DBA
> to respond via email, remove the underscores.
Received on Fri Oct 03 1997 - 00:00:00 CDT