Re: performance problems after increasing redolog size

On Wed, 05 Mar 2003 11:34:26 +0100, Bud Socks wrote:

> Hi there,
>
> due to high frequent logfile switching i have added a new redolog and
> increased the size of the redologs
> from 1 MB to 10 MB. We now have 4 redologs.
>

You should have 8. I hope you have multiplexed.

> Since then we are facing heavy performance losses. For example : a weekly
> performed import needed
> approx. 2h runtime. Now, after the redolog modification this job needs more
> than 24 hours to complete.
>
> How can this be ?

It can't be. Adding redo log groups will have absolute zero performance impact, and something else is amiss.

>
> Are there any corresponding parameters which need to be added to the
> ini<sid>.ora as well ?

No. You can keep adding redo log groups till the cows come home. There are no performance implications from doing so, and no init.ora adjustments to be made.

>
>
>
> Thanks for help
> Bud
Received on Wed Mar 05 2003 - 05:23:37 CST