Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Cannot allocate new log - checkpoint not complete
Fermin,
The "checkpoint incomplete" message is a statement that your DBWR is not keeping up with the pace of redo generation. You can try to "paint over the problem" by adding redo log files. This works when you create enough redo log file space that your peak redo generation event concludes before your system needs to reuse an online redo log file.
The real root cause of this problem is that your DBWR is unable to keep up. Often, this occurs because DBWR has to compete with high I/O loads to your database files. Probably the most common cause of that high I/O load is one or more nasty SQL queries hammering on the device(s).
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Hotsos Clinic 101 in Chicago, London, Reykjavik, Ottawa, Denver - Visit www.hotsos.com for schedule details... - IOUG-A Live 2003, Orlando, 10am Monday 28 April: "Oracle OperationalTiming Data"
-----Original Message-----
Berraondo
Sent: Friday, April 04, 2003 1:19 AM
To: Multiple recipients of list ORACLE-L
Dennis,
This is our actual distribution:
Datafiles belonging to data in a separate disk, name it /baandata Datafiles belonging to index in a separate disk, name it /baanindex And 3 redolog files, two of them in another two separate disks, andthe third one located in the same device as the data files (/baandata).
All of them are mirrored disks.
Your comment makes sense, but if keeping datafiles and one of the redolog files in the same device should affect performance, then I wonder why the "cannot allocate new log, checkpoint not complete" message is affecting to the 3 redolog files and not only to the one located in that datafile device.
I did not think on this. Anyway I have no more disks in which I can split the redologs...
I can not wait for your comments!
Regards,
Fermin.
-----Mensaje original-----
De: root_at_fatcity.com [mailto:root_at_fatcity.com]En nombre de DENNIS
WILLIAMS
Enviado el: jueves, 03 de abril de 2003 17:04
Para: Multiple recipients of list ORACLE-L
Asunto: RE: Cannot allocate new log - checkpoint not complete
Fermin - Connor's reply sparked an idea. By any chance do you have your redo logs on the same device as your data files?
Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
Sent: Thursday, April 03, 2003 5:04 AM
To: Multiple recipients of list ORACLE-L
Basically as the message suggests the redo cannot be recycled until the checkpoint has completed flushing out the cache.
A *workaround* is to add redo log (size or number) but its really a heads-up about your I/O subsystem not being up to keep up under stress.
hth
connor
"GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day"
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: hamcdc_at_yahoo.co.uk Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: DWILLIAMS_at_LIFETOUCH.COM Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Fermin Bernaus Berraondo INET: fbernaus_at_sammic.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Cary Millsap INET: cary.millsap_at_hotsos.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Fri Apr 04 2003 - 09:13:55 CST