Re: Checkpoint Not Complete

From: <wagen123_at_yahoo.com>
Date: 8 Dec 2006 11:04:06 -0800
Message-ID: <1165604646.085893.34700@n67g2000cwd.googlegroups.com>

Adding to Mark's suggestion

Mostly likley the DBWR is unable to flush the dirty buffers from the SGA to disk causing the checkpoint not complete.

You may want to check the following

the OS supports async i/o
check the following init.ora parameters to improve the DBWR write performance filesystemio_options =ASYNCH fast_start_mttr_target=? disk_asynch_io=TRUE

You may want to check Steve Adams paper on DBWR tuning

Hope this helps. Received on Fri Dec 08 2006 - 13:04:06 CST