Re: Redo Log File Sizes

Hi there.,
You got to have a couple of things in mind.

Too big logs:

       Then you MAY loose the active log and all transactions in it in case of media failure.

        How much data can you afford to loose in case of recovery?
        (If you use mirroring of the logs thats not a problem)

Too small logs:

    Each time oracle switches between logs it is a lot of things going on. This may

    cause performance degradation if its to often. Another thing is that a log is not done

    archiving when oracle wants to write transactions to it again, oracle waits (no transactions) until its freed.

Altering logfile size after the database is set in production is not a problem.

    Yoy just add the new files and drops the old ones.

I myself uses a size that makes oracle archive once each hour. Gotta set it when you know how often it switches. Have fun. :)

Petter Henrik Hansen
DBA rspeaker_at_my-dejanews.com wrote:

> I decided to set up a new Oracle installation with 25MB redo logs, for no
> particular reason. Does anyone know of any reasons that redo log files of
> this size would cause any problems (before I put it into production) ??
>
> Thanks.
> Roy
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Tue Nov 03 1998 - 00:00:00 CST