Re: checkpoint over 15 minutes?

These messages in given alert log were full checkpoints caused by log switch.

Incremental checkpoint is an ongoing process, there really isn't a number of them - in essence it's just CKPT process checking how far DBWR is with it's writings and updating this info in controlfiles every 3 seconds. *Incremental* checkpoint entries in alert log are just status messages on checkpoint progress as far as I know, not individual checkpoint completion messages.

Tanel.

• Original Message ----- From: "Alex Gorbachev" <gorbyx_at_gmail.com> To: <tanel.poder.003_at_mail.ee> Cc: <exriscer_at_gmail.com>; <oracle-l_at_freelists.org> Sent: Wednesday, May 24, 2006 7:50 PM Subject: Re: checkpoint over 15 minutes?

> Well, it's also a function of fast_start_mttr_target so reducing it
> should lead to more frequent and short checkpoints. On the other hand,
> it might stress IO subsystem more and give actually an opposite
> result.
>

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