Re: Oracle Loader - faster

In <31f8a075.55754360_at_news.mindspring.com>, efp_at_etechinc.com (Eric Palmer) writes:
>I recently upgraded from a pentium 90 NT to a
>pentium pro 200 NT
>
>Funny thing is that ORacle loader doesn't really
>speed up. I loading many large data files with it.
>
>PerfMon tells me that Loader is only consuming
>a small portion of the CPU.
>
>Any advise on how I can get it to do more work sooner.
>
>TIA
>
>
>--------------------------------------------
>SERIS - SouthEast Regional Internet Society
>Enhancing Your Time On-Line
>http://www.seris.org/
>--------------------------------------------
>Eric F. Palmer
>770.825.0535 Voice - 770.825.0796 Fax
>http://www.etechinc.com/ *** Standard Disclaimer ***
>--------------------------------------------

If you have any indexes on the table you are loading drop them, load the data then recreate them. Also, try using the direct load option.

M.Landa Received on Fri Jul 26 1996 - 00:00:00 CEST