checkpoint not complete
From: Chuck Hamilton <chuckh_at_dvol.com>
Date: 1996/05/30
Message-ID: <31add637.5284444_at_news2.ios.com>#1/1
Date: 1996/05/30
Message-ID: <31add637.5284444_at_news2.ios.com>#1/1
What happens when the database tries to do a log switch and encounters a "Checkpoint no complete" error. Does it wait for the checkpoint to complete before switching to the next log? If so does this mean that all sessions that're changing the database freeze until the checkpoint completes?
I get this error frequently on a data warehouse when doing it's monthly update. I'm using 4 online redo log groups (2 files per group) each 1m in length, and noarchivelog mode. Would adding another log or changing the size of the logs help?
-- Chuck Hamilton chuckh_at_dvol.com Never share a foxhole with anyone braver than yourself!Received on Thu May 30 1996 - 00:00:00 CEST