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: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Wed, 5 Mar 2003 12:16:16 -0000
Message-ID: <3e65ea90$0$6302$ed9e5944@reading.news.pipex.net>


"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 UK
Received on Wed Mar 05 2003 - 06:16:16 CST

Original text of this message

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