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.

Report message to a moderator

Re: bulk loading [message #309690 is a reply to message #309677] Fri, 28 March 2008 08:22 Go to previous message
Frank Naude
Messages: 4581
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?

Report message to a moderator

Previous Topic: Query takes long time to execute first time
Next Topic: Creating Materialized View using Union All Operator
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 23 02:30:25 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.