Re: Redo Log size

From: Howard L. Curtis <hlcurtis_at_mindspring.com>
Date: 1998/01/31
Message-ID: <34D34DA9.C8F05C8C@mindspring.com>#1/1

The size really depends upon the level of change activity (Insert, Update, Delete) that your transactions are generating. The size of the redo logs affect (1) frequency of log switching - which, among other things, triggers a checkpoint - has performance issues (2) the duration of instance recovery should you shutdown abort or otherwise crash the instance - larger logs, longer recovery. General Rule of Thumb: Size the logs such that they switch every 15 minutes. You can examine the alert.log to determine the frequency of log switching you are currently experiencing.

-Howie

joe.story_at_foxinternet.net wrote:

> Is there a optimal size for the Redo logs?
>
> -------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet
Received on Sat Jan 31 1998 - 00:00:00 CST