Re: Question about sizing log files

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Thu, 3 Apr 2003 22:18:48 +0100
Message-ID: <3e8dea17_2@mk-nntp-1.news.uk.worldonline.com>

"Chuck" <ccarson_at_echeeba.com> wrote in message news:3E8B5A67.5070105_at_echeeba.com...
>
> We currently have our redo logs set to 20mb and we get an average of 4
> log switches per minute. Just wondering how high people tend to set redo
> log sizes on very busy OLTP database. We are currently running 8.1.7.4
> on Solaris 8 64-bit. We are currently trying to migrate to 9.2.0.1.
>
> Thanks for any info,
> CC

Chuck:

Is this continuous, or peak?
If it's continuous, then it seems to me you need to go up in size by a factor of 30 to 40.
We're talking half-to-one gb logfiles here, every 5-10 minutes. Can the archiver keep up? Do you have the space?

I'd recommend you resolve these issues before attempting the upgrade to 9i.

Regards,
Paul Received on Thu Apr 03 2003 - 15:18:48 CST