RE: Checkpoint & Redo ratio(High)

2002-01-18 Thread Diego Cutrone
Seema: Regarding the "Checkpoint not completed." message, make sure you're checkpointing only at redo log switches. Check loc_checkpoint_timeout and log_checkpoint_interval values. If these values are OK and you still keep getting "Checkpoint not completed." messages in the alert.log

Re: Checkpoint & Redo ratio(High)

2002-01-17 Thread Peter Gram
Seema First remember the old rule : If it's not broken don't fix it. There is a rule of thumb that redo log switches should happened app. every 30 minutes, but if you se redo log switches happening more often at some times and nobody is complaining then just ignore the it. If you have a perfor