Re: Frequent log switches during sqlldr batch jobs

On 2005-02-04, Connor McDonald <connor_mcdonald_at_yahoo.com> wrote:
> thojens_at_gmx.de wrote:
>>
>> we are running 9.2.0.6 on Solaris. Each night, a bunch of sqlldr batch
>> jobs are run and the redo log switches per hour increase dramatically:
>> 100 and more per hour, while during normal production hours we're at a
>> maximum of about 25 (usually much lower).
>
> make your redo logs massive (ie large enough to handle the sqlldr spike)
> and then set 'archive_lag_target' to control the switching during the
> day

That may well be the easiest solution so far :-) Thank you.

Thorsten

-- 
Look at us, we're dressed like we're in the sixties.
It's the 21st century, we should be dressed like we're in the eighties!
  -- Lindsay Fünke