Home » RDBMS Server » Performance Tuning » bulkloading (oracle9i)
bulkloading [message #309677] Fri, 28 March 2008 07:41 Go to next message
hindolsaha
Messages: 1
Registered: November 2006
Location: UTTARPARA
Junior Member
hi


i am going to insert abt 14 cores data at a time.it is a eod process but it is taking two days minimum.Can u tell me the easiest way for this.
Re: bulk loading [message #309690 is a reply to message #309677] Fri, 28 March 2008 08:22 Go to previous message
Frank Naude
Messages: 4580
Registered: April 1998
Senior Member
Please provide more info. What is the process doing? Can you post the code? Are you using array processing, NOLOGGING, INSERT APPEND, PARALLEL inserts, etc?
Previous Topic: Query takes long time to execute first time
Next Topic: Creating Materialized View using Union All Operator
Goto Forum:
  


Current Time: Thu Jun 27 21:34:19 CDT 2024