Re: Loading LOTS of data into Oracle
From: John Gillespie <jgg_at_waldo.corte-madera.geoquest.slb.com>
Date: 15 Apr 1994 20:19:15 GMT
Message-ID: <2omss3$m98_at_k2.San-Jose.ate.slb.com>
Date: 15 Apr 1994 20:19:15 GMT
Message-ID: <2omss3$m98_at_k2.San-Jose.ate.slb.com>
Some hints on the need for SPEED:
Speed = Array Inserts
Make sure your PRO*C application uses them. The bigger the better.
Minimize use of SQL*Net when doing bulk loads. Make sure all disks are native; no NFS.
Remove as many indices as possible and still maintain your integrity. Received on Fri Apr 15 1994 - 22:19:15 CEST