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: 4518
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: How to reduce the execution timing of SQL Query
Next Topic: SQL Query behaving weirdly in 10g
Goto Forum:
  


Current Time: Mon Aug 21 03:12:28 CDT 2017

Total time taken to generate the page: 0.01090 seconds