Checkpoint not complete error

From: Saad Khan <saad4u_at_gmail.com>
Date: Thu, 23 Apr 2009 14:32:29 -0400
Message-ID: <76b3d4e30904231132q4e595f7m3d1b6caa1b974d21_at_mail.gmail.com>



Hi DBAs,

I've the environment of Oracle 10g (10.2.0.3) on SUSE Linux 9 (32-bit).

I've got 5 redo logfiles of 250MB each, still I'm seeing this the following error messages in the alert log file:

*Thread 1 cannot allocate new log, sequence 17640 Checkpoint not complete*

Users are also complaining of the slow database. What else can I do to make it perform better and get rid of the above message?

Thanks for the help.

Saad

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Apr 23 2009 - 13:32:29 CDT

Original text of this message