Re: Redo Log Size

From: Nuno Souto <nsouto_at_optushome.com.au.nospam>
Date: Wed, 29 Aug 2001 13:38:53 GMT
Message-ID: <3b8cee01.17242940@news>

On 29 Aug 2001 06:29:46 -0700, johan.lorier_at_nl.abb.com (Johan Lorier) wrote:

>I wonder why many small logswitches degrade performance? When there
>are more checkpoints, let's say every 15 minutes, the diskload will be
>distributed more evenly over the day in my opinion, or am I missing
>something?

The smooth operation of the buffer cache will be disrupted for quite a while after a checkpoint.

Cheers
Nuno Souto
nsouto_at_optushome.com.au.nospam Received on Wed Aug 29 2001 - 08:38:53 CDT