Re: 8i archiving question

From: tmgn <tmgn_at_excite.com>
Date: Fri, 23 Jul 1999 13:41:54 -0400
Message-ID: <3798A962.800B4087@excite.com>

Joe,
Make LOG_CHECKPOINT_TIMEOUT=0 and

LOG_CHECKPOINT_INTERVAL=999999 in U'r Init.ora file to make sure that LogSwitches by LGWR occurs only when the Online Redolog file fills up by transactions and not due to timeouts.

This eliminates unnecessary Checkpoints which might reduce Performance..

-Thiru

Joe Gulla wrote:

> I just installed 8i on NT and configured for archivellog mode. my
> parameters
> log_checkpoint_to_alert false
> log_checkpoint_interval 10000
> log_checkpoint_timeout 1800
> I have no apps or users on database yet but log switches and
> archives are being
> created every 1.5 hours
> I cant see why this is happening can anyone give me a suggestion
>
> Thanks joe
Received on Fri Jul 23 1999 - 12:41:54 CDT