Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: performance problems after increasing redolog size
"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message
news:pan.2003.03.05.11.23.36.418727_at_yahoo.com.au...
> > 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.
Could it be that ARCH is now failing to keep up? This should show up in the alert log.
-- Niall Litchfield Oracle DBA Audit Commission UKReceived on Wed Mar 05 2003 - 06:16:16 CST