Re: Big checkpoints

Hi Kirsty,
To my knowledge it's a matter of balancing the number of redo groups and the size of the redo log files..in the simplest sense, smaller redo files checkpoint more often but take less time. Usually in the scheme of things, redo logs are a small proportion of your overall storage so you can afford to add groups if you need to.
A checkpoint roughly every 30 minutes seems common, but there are probably others that will disagree.

Best regards,
Steve

kirsty-purcell wrote:

> Thanks.
> Is there any other way of reducing the checkpoints. For example, if I had a
> much larger DB in that the 400M was fully utilised, would there be any way
> of getting the checkpoints down. Do checkpoints cause much in terms of
> overhead?
>
> What is the norm for checkpoint times?
>
> Thanks again
Received on Tue Apr 10 2001 - 07:28:12 CDT