Re: Any good articles on improving performance of large data loads?

Your question is too general;

We need to know how you are doing
the data load first, 10 hours for 10K
is extremely slow - so there could
be all sorts of simple tips to improve
things.

1. Do you have small redo log files (check alert log for 'checkpoint not complete'
2. Are you using lots of PL/SQL per row - generally very expensive.
3. Are you doing things 'NOLOGGING' (aka unrecoverably) where possible.
4. Are there any bits of code which are continually scanning tables
5. Are you running concurrent loading processes and generating huge amounts of contention.

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

CHANGE username to westes wrote in message <7raj21$hop_at_chronicle.concentric.net>...
>I have a data load for 10K customers that takes over 10 hours to load.
>This same load procedure needs to be able to scale to load over 500K
>customers in 24 hours or less. I'm looking for advice on the most common
>causes of poor performance on a large data load in Oracle 8.
>
>Has anyone written any good articles on how to analyze such situations and
>on how to improve the load performance?
>
>--
>Will
>
>NOTE: To reply, CHANGE the username to westes AT uscsw.com
>
>
>
Received on Fri Sep 10 1999 - 04:36:50 CDT