checkpoint not complete

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!