db_block_checkpoint_batch

2001-02-13 Thread elain he
129614(~1.5days), ie the same time since the database started. The parent DBWR process is waiting on rdbms ipc message and the seconds_in_wait time is 0. Here's the configuration: DB 7.3.4 db_writer=10 async_io disable Solaris 2.6/Sun T3 Array _db_block_write_batch=512 db_block_checkpoint_

Re: db_block_checkpoint_batch

2001-02-13 Thread Riyaj_Shamsudeen
ng no work. So, this is fine too. db_block_checkpoint_batch determines what portion of db writes can be used for the slow checkpoints (in 7.3). By setting this to high value, the checkpoint will complete faster, but the speed at which DBWR cleans the buffer cache may be slightly slower. So more

Re: db_block_checkpoint_batch

2001-02-13 Thread elain he
ply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: Re: db_block_checkpoint_batch >Date: Tue, 13 Feb 2001 09:16:33 -0800 > > >Hi elain > I have not personally encountered performance degradation setting >this >to hig