Re: performance problems after increasing redolog size

From: Bud Socks <bud_socks_at_gmx.de>
Date: Wed, 5 Mar 2003 12:01:02 +0100
Message-ID: <b44ldg$1s59vf$1@ID-2182.news.dfncis.de>

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

Hi Stefan,
sorry - forgot to mention :
i`ve modified the size of the other redologfiles as well of course. They all got 10 MB. (dropped & recreated) What i noticed as well is that redolog no. 3+4 have the same filesystem time&date.
Don`t know if this has something to do with the performance issue. A select on the v$log shows (of course depending on transaction load) inactive
inactive
inactive
current

Thanks for help

Bud Received on Wed Mar 05 2003 - 05:01:02 CST