Re: Performance Diagnosis

From: Matt <mccmx_at_hotmail.com>
Date: 22 Jun 2004 00:59:36 -0700
Message-ID: <cfee5bcf.0406212359.7c0ffe8f@posting.google.com>

> > _db_block_write_batch defaults to the least of:

> > . db_files * db_file_simultaneous_writes / 2
> > . db_block_buffers / 4

I think this formula is out of date, quote from Steve Adams' site about DBWR changes in 8i:

"The value is now set with _db_writer_chunk_writes rather than _db_block_write_batch. The default value appears to be a platform
specific constant - that is, not derived from any other parameters."

So it looks like I have to explicitly set this value with "_db_writer_chunk_writes".

"db_file_simultaneous_writes" doesn't exist either... Received on Tue Jun 22 2004 - 02:59:36 CDT