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,
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-lReceived on Thu Apr 23 2009 - 13:32:29 CDT