dbTalk Databases Forums  

Checkpoint not complete

comp.databases.oracle.misc comp.databases.oracle.misc


Discuss Checkpoint not complete in the comp.databases.oracle.misc forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Michael
 
Posts: n/a

Default Checkpoint not complete - 09-21-2009 , 08:02 AM






We have 10 redo logs each of 150M in size and 2 members in each group.
We have been constanly getting a message of CHECKPOINT NOT
COMPLETE.

What can we do to get rid of this checkpoint error? Should we
increase the size of our redo logs?

Thanks in advance for your help.


Michael

Reply With Quote
  #2  
Old   
Frank van Bortel
 
Posts: n/a

Default Re: Checkpoint not complete - 10-29-2009 , 07:58 AM






On 21 sep, 14:02, Michael <mbulch... (AT) gmail (DOT) com> wrote:
Quote:
We have 10 redo logs each of 150M in size and 2 members in each group.
We have been constanly getting a message of CHECKPOINT NOT
COMPLETE.

What can we do to get rid of this checkpoint error? *Should we
increase the size of our redo logs?

Thanks in advance for your help.

Michael
150MB is pretty small... ROT is 1GB, three groups minimum for me
(but... beware of ROTs).
Mark has given pretty solid advise, that is a lot more precise.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.