Re: LOG_CHECKPOINT_INTERVAL

Andy Carruthers wrote:

> We're having a discussion regarding this parameter and what happens if
> it is set to 0.
>
> Oracle Support say that this is a __BAD__ thing to do but haven't given
> a substansive reason why except to say that it forces lots of activity.
>

Support is right. lgwr will post ckpt or dbwr indicating a checkpoint is needed.nothing will be written to the alert.log though.

> On a recent Oracle Performance Tuning (v7) course, my boss was told to
> set this to 0 in order to disable checkpoints (except when the log file
> changes over).
>

maybe they ment: log_checkpoint_timeout? (OK to set to zero!)

> The Oracle Performance Tuning manual (O'Reilly & Associates) implies
> that the only valid parameters are 2 and above.

hmm.. don't know where they got this from...

Saar. Received on Wed Jun 17 1998 - 13:57:37 CDT