Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

"Checkpoint not complete" hangs!

emre baranselSep 18 2009 — edited Sep 18 2009

Hi everyone;

I see "Checkpoint not complete" in the alertlog but normally oracle just waits seconds then checkpoints and go on... But the problem is, database sometimes hangs with this message for minutes and never respond until i checkpoint manually.

I made the necessary changes to avoid "Checkpoint not complete" message. Number of Redolog groups was increased, redolog size was increased, 5 dbwr was configured.

But the real problem is not the message, oracle cannot go over this message and hangs!!

10.2.0.1.0 - on hp-ux 11.31

Thanks for your help...

Edited by: emre baransel on Sep 18, 2009 10:27 AM

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 16 2009

Added on Sep 18 2009

#general-database-discussions

5 comments

1,026 views