Re: 8i archiving question

From: David Sisk <davesisk_at_ipass.net>
Date: Sun, 25 Jul 1999 14:49:02 -0400
Message-ID: <cRIm3.65$tp2.157@news.ipass.net>

The log_checkpoint_timeout setting. 1800 seconds is 30 minutes, so you should be getting a checkpoint (and a resulting log switch) every 30 minutes.

See the site below for details about this setting (performance -> instance, look at checkpoints and log buffer).

--
David C. Sisk
Need tech info on Oracle? Visit The Unofficial ORACLE on NT site at http://www.ipass.net/~davesisk/oont.htm Like original music? Listen to song samples and buy a CD at http://www.mp3.com/disparityofcult

Joe Gulla wrote in message <3798A067.6CF414CC_at_erols.com>...
>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 Sun Jul 25 1999 - 13:49:02 CDT