Re: Redo Log problem

From: Chuck Hamilton <chuckh_at_safeaccess.net>
Date: Wed, 21 Oct 1998 14:35:19 GMT
Message-ID: <362ff075.7662685@news2.axs2000.net>

On Mon, 19 Oct 1998 22:06:21 +0800, Horace Chow <horacecw_at_netvigator.com> wrote:

>Another workaround is to add more group of redo log. As usual, 3 or
>more groups of redo logs are enough for a small system.
>
>Horace

Larger log files is a better solution. Remember that when you switch log files, you also perform an i/o intensive checkpoint. Larger log files will reduce checkpointing and solve the other problem too.

I'd start with three 10mb logs and go from there. If you see you're checkpointing too often still, increase the size further. --
Chuck Hamilton
chuckh_at_safeaccess.net

This message delivered by electronic sled dogs! WOOF! Received on Wed Oct 21 1998 - 09:35:19 CDT