Re: Frequent log switches during sqlldr batch jobs

thojens_at_gmx.de wrote:
>
> Hi,
>
> 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).
>
> However, I don't see any "Checkpoint not complete" messages in our
> alert file. Does it make sense to increase the redo log file size (The
> amount of data to be written would be same, wouldn't it)? What other
> possibilities do I have to check if there are performance problems when
> switching log files so often?
>
> Thorsten

easy in v9

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

hth
connor

-- 
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
Co-author: "Oracle Insight - Tales of the OakTable"

web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com


"GIVE a man a fish and he will eat for a day. But TEACH him how to fish,
and...he will sit in a boat and drink beer all day"

------------------------------------------------------------