Re: Write Complete Waits

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 10 Dec 1999 08:33:59 -0000
Message-ID: <944815611.21939.0.nnrp-14.9e984b29@news.demon.co.uk>

And of course there are always bugs, so a few versions on some platforms get it wrong and bang it up to 4096 or 2048 unless you
set "_db_block_write_batch explicitly".

You can check this one by looking at x$kvit, for the row ''DB writer IO clump'.

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Steve Adams wrote in message <38501c4c.58449535_at_news.eagles.bbs.net.au>...
>Hi Neil,
>
>Yes, the internal write batch size is derived from these parameters.
>The basic formula is db_files * db_file_simultaneous_writes / 2.
>There are some other limits such as db_block_buffers and the platform
>specific maximum number of concurrent asynchronous I/O operations, but
>those would not be relevant in this case.
>
>Regards,
>Steve Adams
>http://www.ixora.com.au/
>http://www.oreilly.com/catalog/orinternals/
>http://www.christianity.com.au/
>
Received on Fri Dec 10 1999 - 02:33:59 CST