Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: db_block_checkpoint_batch

Re: db_block_checkpoint_batch

From: <bdg_at_hotmail.com>
Date: 1998/03/10
Message-ID: <6e46oc$129$1@nnrp1.dejanews.com>#1/1

In article <35046ec0.2852740736_at_newsserver.trl.oz.au>,   steveadams_at_acslink.net.au (Steve Adams) wrote:
>
> Hello Brian,
>
> The default value for db_block_checkpoint_batch is 8 and the maximum
> is db_files * db_file_simultaneous_writes / 2 up to a maximum of
> . . .
> buffer waits' are introduced. In most case, this means that you should
> start with db_block_checkpoint_batch set to 2 * db_files.
>
> Hope this helps,
> Regards,
> Steve Adams
> steveadams_at_acslink.net.au
>
> ----------
> On Fri, 06 Mar 1998 08:48:54 -0600, bdg_at_hotmail.com wrote:
>
> >I'm trying to eliminate "Checkpoint not complete." messages in
> > . . .
> >amount of time taken to to complete a checkpoint would also be
> >helpful.
>
>

Exactly the type of information I was looking for. Thanks.

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Tue Mar 10 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US