Re: Loading LOTS of data into Oracle
Date: Wed, 20 Apr 94 01:16:02 GMT
Message-ID: <766804562.88snx_at_aleytys.pc.my>
In article <766305579snx_at_hkchan.pc.my> hkchan_at_hkchan.jaring.my writes:
>
>In article <1994Apr1.213159.16029_at_PacBell.COM> s4xmakm_at_srv.PacBell.COM writes:
>
> > We are loading millions of records into an Oracle
> > database running on HP-UX on an HP 9000/890.
> > Using ProC Oracle can only handle about 24 records
> > addition per second.
> >
> > What kind of optimization would you recommend?
> >
>I am interested in the answer to this question too. I have tried ODBC
>call level interface for quick insertion. The quickest speed it can go
>is only 10 records per second. The loading is done to a NetWare 3.11
>server on 486/66.
>
>Short of using load data module directly, is there any other way to
>speed this up?
Is there any particular reason you can't use Oracle Data Loader for this purpose?
+---------------------------------+-------------------------------------------+ |Philip Chee: philip_at_aleytys.pc.my| This is a work of fiction.Any resemblance | |Tasek Cement Berhad | to persons living or dead is completely | |P.O.Box 254, 30908 Ipoh, MALAYSIA| coincidental. The creator of this article | |Voice: +605-551-011 | has asserted its moral right to be | | Fax: +605-566-142 | identified as the author. | +-------------------Eigi-Eru-Enn-Allir-Jomsvikingar-Daudir!-------------------+Received on Wed Apr 20 1994 - 03:16:02 CEST