Re: Big Checkpoints

From: Steve Long <steven.long_at_erols.com>
Date: Mon, 9 Apr 2001 07:38:14 -0400
Message-ID: <9as73t$opd$1@bob.news.rcn.net>

for a short term solution, you should review the Oracle documentation on init parameters related to checkpoints (otn.oracle.com) all of the oracle docs are on-line and free to access. then, you should get a good tuning book. check OReiley Press titles.

"kirsty-purcell" <kirsty-purcell_at_supanet.com> wrote in message news:0v7pa9.npb.ln_at_meszaros.user.cis.dfn.de...
> Hi,
> I've got a small (2Gb), database on 8.1.6 running on NT4. The server has
> 3CPU, 2.5Gb mem and RAID1 for reo, RAID1 for archlogs and RAID5 for data.
>
> The problem I'm getting is that a log switch checkpoint takes 30 mins to
> complete, even though it doesn't look as though its doing anything.
>
> I've tried setting log_checkPoint_timeout but that doesn't seem to do
> anything (how does this work).
> Is there any recommended setting for db_block_max_dirty?
>
> The only disk activity appears to be a write to the control file every few
> seconds. What does Oracle do in a checkpoint?
>
> Any help would be great.
>
>
Received on Mon Apr 09 2001 - 06:38:14 CDT