Re: performance problems after increasing redolog size

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Thu, 06 Mar 2003 06:37:01 +1100
Message-Id: <pan.2003.03.05.19.36.59.512043@yahoo.com.au>

On Wed, 05 Mar 2003 12:16:16 +0000, Niall Litchfield wrote:

> "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.

If his logs had increased to 100GB, I'd buy this! But if ARCH can't cope with a 10MB log, something is seriously amiss...

Cheers,
HJR
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
Received on Wed Mar 05 2003 - 13:37:01 CST