Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: performance problems after increasing redolog size

Re: performance problems after increasing redolog size

From: D.Y. <dyou98_at_aol.com>
Date: 5 Mar 2003 08:32:16 -0800
Message-ID: <f369a0eb.0303050832.27c56e19@posting.google.com>


Did you move these redo logs to different disks, e.g. from mirrored to raid5?

"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 - 10:32:16 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US