Re: checkpoint over 15 minutes?
- From: "LS Cheng" <exriscer@xxxxxxxxx>
- To: tanel.poder.003@xxxxxxx
- Date: Wed, 24 May 2006 15:07:59 +0200
I had two user processes blocked by the CKPT process (TC Lock) I am not sure why a checkpoint can block user sessions :-?
On 5/24/06, Tanel Põder <tanel.poder.003@xxxxxxx> 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.
----- Original Message ----- From: "Alex Gorbachev" <gorbyx@xxxxxxxxx> To: <tanel.poder.003@xxxxxxx> Cc: <exriscer@xxxxxxxxx>; <oracle-l@xxxxxxxxxxxxx> 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. >