Re: Size of files. Can you estimate?

amerar_at_iwc.net wrote:
> Charles Hooper wrote:
> > From your posting, you have only three log files, each roughly 3MB in
> > size. Based on your response to Mark, you are switching log files
> > roughly every 9 to 30 seconds. Log file switches ideally should take
> > place every 20 to 30 minutes. As the system is configured right now, I
> > predict that your database will grind to a halt every 9 to 30 seconds
> > if the system is set to archive redo mode. You need to significantly
> > increase the size and number of online redo logs.
> >
> > Charles Hooper
> > PC Support Specialist
> > K&M Machine-Fabricating, Inc.
>
> Thanks for your suggestion Charles. Based on that, I would think that
> not only do the log files need to be increased in size, but we probably
> need more than 3 log files.
>
> I've also looked into the alert log and seen this error:
>
> Thread 1 cannot allocate new log, sequence 584375 Checkpoint not
> complete
>
> My guess is that this also has something to do with the size and
> frequency of the switches, right?

Possibly yes. I recall seeing a post in Metalink that sometimes the above will be logged, even when the system is operating properly.

Checking the database on my system with the lowest activity (1 user, maybe 10MB of redo generated per day), with forced hourly redo log switches - 16MB per redo log, 4 total redo logs: Thread 1 cannot allocate new log, sequence 6568 Private strand flush not complete

Looks quite similar to what you posted.

Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc. Received on Fri Dec 08 2006 - 10:59:06 CST