Re: Checkpoints
From: The Magnet <art_at_unsu.com>
Date: Mon, 21 Sep 2009 17:26:57 -0700 (PDT)
Message-ID: <5ba37223-4b74-4c95-8bee-c8c4161c9b39_at_q14g2000vbi.googlegroups.com>
On Sep 21, 6:51 pm, John Hurley <johnbhur..._at_sbcglobal.net> wrote:
> 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.
Date: Mon, 21 Sep 2009 17:26:57 -0700 (PDT)
Message-ID: <5ba37223-4b74-4c95-8bee-c8c4161c9b39_at_q14g2000vbi.googlegroups.com>
On Sep 21, 6:51 pm, John Hurley <johnbhur..._at_sbcglobal.net> wrote:
> 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.
Well, I ran a query and it looks like busy times looked like: 8:00am (from 5 - 21 log switches) and 4:00am (from 18 - 35 log switches).
Make them larger? Maybe 150 meg is to small? Received on Mon Sep 21 2009 - 19:26:57 CDT