Re: VLDB Redo Log Sizing Suggestions

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Fri, 04 Jul 2003 20:59:48 +0200
Message-ID: <mjjbgv0j2fcf96lljsqs6tke2804oo4v00@4ax.com>

On Fri, 4 Jul 2003 09:25:36 -0400, "Charles Davis" <cdavis10717_at_comcast.net> wrote:

>
>Oracle wants me to archive about every 20-30 minutes. Is a re-sizing as
>simple as tripling or quadrupling the re-do log sizes?

It is. AND it can be done online by alter database drop logfile group alter database add logfile group. If a group is active, just alter system switch logfile

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri Jul 04 2003 - 13:59:48 CDT