Re: different redo needs same database

From: Tanel Põder <tanel.poder.003_at_mail.ee>
Date: Tue, 6 Apr 2004 15:07:01 +0300
Message-ID: <08d401c41bcf$ab281ed0$b6a623d5@porgand>

Hi!

Just create big redologs and keep them. If you definitely want to archive them after some intervals, then use archive_lag_target parameter to set maximum interval of time a logfile can accommodate redo (a logswitch will be forced after the interval since last logswitch).

Also, I think it's reasonable to go with incremental checkpoints (setting fast_start_mttr_target or fast_start_io_target) instead of having your log_checkpoint_* parameters with ridiculously low values.

Tanel.

Original Message ----- From: "Jeroen van Sluisdam" <jeroen.van.sluisdam_at_vrijuit.nl> To: <oracle-l_at_freelists.org> Sent: Tuesday, April 06, 2004 11:28 AM Subject: different redo needs same database

> Hi,
>
> I'm trying to improve my redo settings because I have logswitches during
> daytime every
> 2 to 4 hours and at night during batches every couple of minutes and a few
> times
> within 1 minutes 2 logfile switches. With statspack (interval complete day
> including night(
> I also see

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Tue Apr 06 2004 - 07:03:27 CDT