Re: Size of files. Can you estimate?

Charles Hooper wrote:
> 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.

I think I'm just going to guess that each archive log file will be roughly 6 megs.........and, that after a successful backup or the database, the previous archive logs are not needed.

This place is short on disk space as it is.......... Received on Mon Dec 11 2006 - 09:29:17 CST