Re: Frequent log switches during sqlldr batch jobs

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Thu, 03 Feb 2005 09:28:49 +0100
Message-ID: <ctsn90$uue$1@news4.zwoll1.ov.home.nl>

Thorsten Jens wrote:
> Frank van Bortel wrote:
>

>>Take about 5 switches per hour, then. Gives you 12 minutes
>>worth of transactions to loose when the current redolog file
>>crashes.

>
>
> If I sized the redo logs to have ~5 switches per hour during high load
> times, then I'd have almost no switches at all during the day -- which
> would mean a lot of lost work in the worst case.
> Thorsten
>

Ah, no: 5 hourly during "normal" loads. And it's only an indication; I wouldn't start to worry if it's 20 in your case - all runs well with that aspect (no timeouts, as you stated).

As said, there's some risk/time to recover (MTTR - mean time to recover) involved here, too.

As you still haven't revealed your peak load, nor see any timeouts, I would not change a thing, given the information available

-- 
Regards,
Frank van Bortel

Received on Thu Feb 03 2005 - 02:28:49 CST