Re: Database Tuning Question

rsands_at_mail.intracorp.com wrote:
>
> Running a week-long program, it processes 40,000 records an hour running alone
> on the weekend. It process 60,000 an hour when busy during weekdays. What are
> the most likely database settings that could cause this symptom.

        Do you have any nasty cron jobs running against the database on weekends?
Jobs like analyze with compute statistics and index rebuilds can cause the problems you are seeing.

-- 
Jerry Gitomer 
Once I learned how to spell DBA, I became one