Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: db_block_checkpoint_batch
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