Re: Checkpoints
From: joel garry <joel-garry_at_home.com>
Date: Fri, 2 Oct 2009 13:25:06 -0700 (PDT)
Message-ID: <dfd4821d-4287-47fd-9cf6-fb8fcc2c6251_at_b3g2000pre.googlegroups.com>
On Oct 2, 1:10 pm, Srivenu Kadiyala <sriv..._at_hotmail.com> wrote:
> I would go for atleast 500MB to give more breathing space for dbwr to
> checkpoint before the next log switch.
> Also whats the value of FAST_START_MTTR_TARGET?
> On several of the servers (10.2.0.4 on HP) i see that the parameter
> does not work as seemlessly as is specified in the doc.
> If i'm in your shoes, I would first set my log files to atleast 512 MB
> and if still facing the checkpoint issue, would start tinkering with
> FAST_START_MTTR_TARGET.
> regards
> srivenu
Date: Fri, 2 Oct 2009 13:25:06 -0700 (PDT)
Message-ID: <dfd4821d-4287-47fd-9cf6-fb8fcc2c6251_at_b3g2000pre.googlegroups.com>
On Oct 2, 1:10 pm, Srivenu Kadiyala <sriv..._at_hotmail.com> wrote:
> I would go for atleast 500MB to give more breathing space for dbwr to
> checkpoint before the next log switch.
> Also whats the value of FAST_START_MTTR_TARGET?
> On several of the servers (10.2.0.4 on HP) i see that the parameter
> does not work as seemlessly as is specified in the doc.
> If i'm in your shoes, I would first set my log files to atleast 512 MB
> and if still facing the checkpoint issue, would start tinkering with
> FAST_START_MTTR_TARGET.
> regards
> srivenu
Rather than just pulling values out of your, um, hat, why not look at optimal_logfile_size from v$instance_recovery? See metalink Note: 274264.1 or the performance tuning guide.
jg
-- _at_home.com is bogus. Who is Diego and why is he flipping off Oracle aces off the coast of Africa? Hi, I'd like to share a Google Maps link with you. Link: http://maps.google.com/maps/ms?ie=UTF8&hl=en&om=1&source=embed&oe=UTF8&start=400&num=100&msa=0&msid=101461418394975592073.000439f71111bb8cdc3b5&ll=3.162456,-22.939453&spn=58.230056,79.013672&z=4Received on Fri Oct 02 2009 - 15:25:06 CDT