Re: checkpoint over 15 minutes?

Hi Tanel

I had two user processes blocked by the CKPT process (TC Lock) I am not sure why a checkpoint can block user sessions :-?

Cheers

On 5/24/06, Tanel Põder <tanel.poder.003_at_mail.ee> wrote:
>
> 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
>
>
>

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