Re: cannot allocate new log, sequence #

I agree. I usually make 10 - 15 MB logfiles, but put in 5 or 6 of them. They still sometimes change every 20 seconds, but the OS has time to finish writing before it gets through them all,

If you're on a slow area of utilization, and moving towards the end of a 65Mb logfile, utilization pics up, you may go through 65Mb of changes fast. You may also want to move your logfiles to a disc that is not heavily used during your peak.

Ronny Ivarsen
ivarsen_at_online.no

Thomas Kyte skrev i meldingen <360ca130.10400435_at_192.86.155.100>...
>A copy of this was sent to aaronurbain_at_bigfoot.com
>(if that email address didn't require changing)
>On Mon, 21 Sep 1998 00:10:19 GMT, you wrote:
>
>>My logs switch every 2 hours under load and are 64M.
>>
>>I searched TNS (this news server) for this common line in my alert log but
>>only found that if I make my logfiles larger, the troublesome message will
go
>>away.
>>
>>Sure I can make them larger, and the message may vanish, but anyone know
the
>>details behind the message?
>>
>>mabey my swr is too high? Corrosion on my connector ends? I'm stumped.
>>
>>-Aaron
>> kd7bwz
>>
>>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>
>the infamous "checkpoint not complete, cannot allocate new log" message.
>
>this occurrs when Oracle attempts to reuse a log file but the checkpoint
that
>would flush the blocks that may have redo in this log file has not yet
completed
>-- we must wait until that checkpoint completes before we can reuse that
file --
>thats when this message is printed. during this time (when we cannot
allocate a
>new log) processing is suspended in the database while the checkpoint is
made to
>complete ASAP.
>
>The major way to relieve this is to have sufficient log to carry you
through
>peak times. that way, we can complete the checkpoint while you are not
busy.
>
>also make sure your checkpoints happen as fast as they can (eg: enable
ASYNC IO
>or configure >1 DBWR if ansyc IO cannot be used, make sure disks are not
>contending with other apps and so on)
>
>Another way is to make the log files smaller, hence increasing the
frequency
>with which we checkpoint (log checkpoint interval and other init.ora
parameters
>achieve the same effect btw).
>
>I myself prefer to use a modest sized log file (around 25meg) and will add
>logfiles until these messages cease...
>
>Thomas Kyte
>tkyte_at_us.oracle.com
>Oracle Government
>Herndon VA
>
>--
>http://govt.us.oracle.com/ -- downloadable utilities
>
>---------------------------------------------------------------------------
-
>Opinions are mine and do not necessarily reflect those of Oracle
Corporation
>
>Anti-Anti Spam Msg: if you want an answer emailed to you,
>you have to make it easy to get email to you. Any bounced
>email will be treated the same way i treat SPAM-- I delete it.
Received on Tue Sep 22 1998 - 16:26:04 CDT