Re: Change the timeout value for DBWR process

From: Winnie Liu <poohland_at_hotmail.com>
Date: Tue, 4 Aug 1998 20:00:08 -0700
Message-ID: <6q8hjj$dr1@dfw-ixnews8.ix.netcom.com>

How about the log files? Have you check to see if the redo logfiles is too small? A log switch will also cause a checkpoint and cause the DBWR to write the data to the disk. Do check the log files. If not, check to see if your database buffer cache is too small (check the db_buffer parameter in the init.ora file). If it is too small and there is too many transactions on the system, the DBWR need to read in new data all the time.

hope this can help

Winnie

Venkata Yella wrote in message <35C7A281.328AE952_at_eng.sun.com>...
>Hi,
>
>Does anyone know how to change the timeout value for DBWR process? This
>times out every 3 seconds and does a lot of I/O. I am running a bench
>mark. I increased the value of Checkpoint interval. So, checkpoint is
>not causing the DBWR to do I/O. Any one encountered this problem
>before??
>
>Any suggestion would be very appreciated.
>
>Thanks.
>
>--
>-Yella
>
>
>
Received on Tue Aug 04 1998 - 22:00:08 CDT