Re: Checkpoints

From: joel garry <joel-garry_at_home.com>
Date: Mon, 5 Oct 2009 11:12:37 -0700 (PDT)
Message-ID: <ec0c9355-0735-4222-b3c7-bd902629cc38_at_d9g2000prh.googlegroups.com>

On Oct 5, 10:02 am, Srivenu Kadiyala <sriv..._at_hotmail.com> wrote:
> My suggestions were based on the data provided.
> The redo generation around 5GB per hour during peak. So a 512 MB redo
> log would cause a switch every 6 mins during peak.
> FAST_START_MTTR_TARGET could be set at 120-180.
> Monitoring stats like "physical writes" and "physical writes non
> checkpoint" before and after the change should give an idea of the
> extra checkpoint load put on the system due to this change.
> regards
> srivenu

The information provided does not say that 5GB per hour is evenly spread across the hour. I still don't understand why you wouldn't simply start with the advisor. I'd add that scripts found randomly on the intertubes may be suspect. Wouldn't you want to use a script with a granularity of 6 minutes if you were aiming for that?

Frankly, I was surprised at how accurate the advisor was for my system.

jg

--
_at_home.com is bogus.
2005: HP's Carly Fiorini folds struggling PC unit into profitable
printer unit.  HP board fired Carly, hired Mark Hurd, who separated
the two units.  PC unit slashed costs, became more efficient.  Now,
printer business is most profitable, but not keeping up with rest of
HP's profitability.  So now Hurd is combining the two units.  In HP's
fiscal quarter ended July 31, PCs produced $8.43 billion in revenue
and $386 million in earnings, and accounted for 12 percent of HP's
profits. Printer and ink generated revenue of $5.66 billion and $960
million in earnings, for 30 percent of overall profits. In 2004,
printers and ink accounted for more than 70 percent of HP profits,
while PCs were less than 5 percent.  I don't understand how the PC
business is the same as the printer business, and why a lower
profitability unit should be in charge of a higher profitability unit,
so I guess I'll never be running HP.

Received on Mon Oct 05 2009 - 13:12:37 CDT