Re: performance problems after increasing redolog size

From: Stephan Bressler <stephan.bressler_at_siemens.com>
Date: Wed, 5 Mar 2003 11:42:13 +0100
Message-ID: <b44k7f$jeu$1@news.mch.sbs.de>

Hi,

you had 3 redologs 1M each and added one 10M redolog? Got this right? I don't think this make any sense. You should create redologs of equal size and get rid of the old (small) ones.

If you moved from 3 1M to 4 10M files, I cannot think of any reson why this should slow down the database.

I think you did some more changes.

Stephan

"Bud Socks" <bud_socks_at_gmx.de> wrote in message news:b44jrk$1r08lf$1_at_ID-2182.news.dfncis.de...
> 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.
>
> 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 ?
>
> Are there any corresponding parameters which need to be added to the
> ini<sid>.ora as well ?
>
>
>
> Thanks for help
> Bud
>
>
>
>
>
>
>
>
Received on Wed Mar 05 2003 - 04:42:13 CST