Re: Archive log created every 2 minutes.

From: bgbgbg <brian.gallagher_at_iona.com>
Date: Wed, 3 Nov 1999 16:55:48 -0000
Message-ID: <7vppgs$f84$1@bvweb.dublin.iona.ie>

you may have ARCH checkpoiunting too often if u set
log_checkpoint_timeout = 0 and
log_checkpoint_interval = 9999999999999

in yr init.ora checkpoints will only occur when logswitches occur

hth

regards
brian

duraisingh <duraisingh_at_yahoo.com> wrote in message news:381F3B76.8B979BF8_at_yahoo.com...
> Hellow Gurus:
>
> My database is running oracle 7.3.3 on AIX 4.2
> is on archivelog mode.
> Normally the redologs are switched for every 20 minutes.
> But for the last one week it is switching for every 2 minutes most of
> the times.So as a result it create lot of archive logs in the archive
> destination. It put additional maintenance as we have to do a frequent
> backup of archivelogs.
> Can you guys experience these kind of problems.
> How can I recify that. Should I increase the size of the archivelogs .
> At present we have 4 log groups with 2 members each with a size of 30mb.
>
> Any clues.
> John Durai
>
>
Received on Wed Nov 03 1999 - 10:55:48 CST