* How to load faster with SQL Loader on NT?
From: edwin rutsch <edwinr_at_wyp.net>
Date: 1995/12/26
Message-ID: <edwinr-2612951451070001_at_quadra.wyp.net>#1/1
Date: 1995/12/26
Message-ID: <edwinr-2612951451070001_at_quadra.wyp.net>#1/1
We are using SQL Loader with oracle workgroup 7.1 on Windows NT.
We are trying to load data from a flat file into our database but when we use SQL Loader it only loads 64 records at a time. This is very slow.
On the advanced features of SQL Loader we bump up the
Rows per Commit to 1000 from the default of 64
and bump up the
Minimum Dind Array from the default of 65024 bytes
to 1,000,000 or 2,000,000
but when we load it always defaults back to 64 records. Any idea of what can be done to load data faster using SQL Loader?
thanks
edwin
-- wow amazing _ ,/| \\// '\`o.O' incredible ? ~ ~ =(_ _)= \|/ \\\|/// _at_ @ |U| ^ ^ \\ ~ ~ // * / | \ ( O O ) (/ _at_ @ /) ___oOO_(===)_OOo___/_|__\___.ooO__U__Ooo.___oOOo_( )_oOOo______ ( ) =================================================(_)============ wyp.net World Yellow Pages Network Search our database of over 12 million business listings We offer a free web page to every business and organization in North America go for it --- __0 __ __* ---- _`\<,_ ---- ___at_ __ - _-\<'_ (*)/ (*) ---- _`\<,_ - (*)/ (*) (*)/ (*) Edwin Rutsch World Yellow Pages Network tel:510-524-4495 e-mail:edwinr_at_wyp.net http://wyp.net ================================================================Received on Tue Dec 26 1995 - 00:00:00 CET