Re: DBWR write chunk

From: Andrew Mobbs <andrewm_at_chiark.greenend.org.uk>
Date: 19 Feb 2001 14:52:51 +0000 (GMT)
Message-ID: <Nqn*qZePo@news.chiark.greenend.org.uk>

Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk> wrote:
>
>This is the number of blocks that dbwr
>will attempt to find and write when called
>by a process that needs some buffers
>freed. It does not imply anything about
>continuous buffers, or single write sizes.
>
>In some versions of Oracle, it can be set
>by the value of _db_block_write_batch.

I thought that "DBWR write chunk" was the number of writes that DBWR would wait to return before putting the blocks from those writes back on the LRU lists.

It can be set (in 8.1.6 at least) by _db_writer_chunk_writes

Andrew.

-- 
Andrew Mobbs - http://www.chiark.greenend.org.uk/~andrewm/

Received on Mon Feb 19 2001 - 08:52:51 CST