Re: Checkpoints

From: John Hurley <johnbhurley_at_sbcglobal.net>
Date: Mon, 21 Sep 2009 16:51:40 -0700 (PDT)
Message-ID: <21b4c89e-11b0-4b59-8197-63e1970e93e6_at_f33g2000vbm.googlegroups.com>

On Sep 21, 3:40 pm, The Magnet <a..._at_unsu.com> wrote:

snip

> We are on 10gr2.  We have 10 redo logs, each 150 megs.  We are getting
> a lot of checkpoint not complete errors.  After doing some reading I
> see that it says not to mix FAST_START_MTTR_TARGET with
> LOG_CHECKPOINT_INTERVAL.
>
> I could keep adding more and more and larger and larger redo logs, but
> is that really the right answer?  I've looked and all apps have decent
> commits in them......

How many gig of online redo are you generating each day?

How much per hour during the busy times?

Everyone has different ideas here but most of my OLTP systems have like 20 512 meg files with no real reason not to make them bigger except I like archived logs under a gig. Received on Mon Sep 21 2009 - 18:51:40 CDT