Re: Loading LOTS of data into Oracle

From: Philip Chee <philip_at_aleytys.pc.my>
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

Original text of this message