Re: Performance Diagnosis

From: Matt <mccmx_at_hotmail.com>
Date: 21 Jun 2004 02:31:46 -0700
Message-ID: <cfee5bcf.0406210131.46b97020@posting.google.com>

> From Steve Adams's ixora site:
>
> rdbms ipc reply waits indicate the either DBWn's write batch is too
> big, or you are checkpointing too intensively. Make sure that db_files
> is not much higher than the number of datafiles that you actually
> have. If you are using incremental checkpoints (
> db_block_max_dirty_target) don't be too ambitious.

As far as I was aware, the db_files parameter had no effect on the DBWR write batch size in 8i (can't access ixora at the moment to confirm).

I haven't set db_block_max_dirty_target explicitly so this is the default value.

Matt Received on Mon Jun 21 2004 - 04:31:46 CDT