If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Oracle > Inserting Massive Amounts of Data

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 08-23-10, 14:57
VentureFree VentureFree is offline
Registered User
 
Join Date: Dec 2007
Posts: 27
Inserting Massive Amounts of Data

I've got a program that's basically just looping through 10,000 some odd rows of calculated data and inserting each one individually into a table on an Oracle 10g database. The server takes a noticeable performance hit when I do this. Is there a more efficient way of inserting 10,000 + records into Oracle at one time? Maybe write to a file and do some kind of bulk insert?
Reply With Quote
  #2 (permalink)  
Old 08-23-10, 15:05
anacedent anacedent is offline
Registered User
 
Join Date: Aug 2003
Location: Where the Surf Meets the Turf @Del Mar, CA
Posts: 6,407
ALWAYS
Post Operating System (OS) name & version for DB server system.
Post results of
SELECT * from v$version;

Do some research on BULK LOAD
__________________
You can lead some folks to knowledge, but you can not make them think.
The average person thinks he's above average!
For most folks, they don't know, what they don't know.
Reply With Quote
  #3 (permalink)  
Old 08-23-10, 15:19
PriorityParts PriorityParts is offline
Registered User
 
Join Date: Aug 2010
Location: NYC
Posts: 10
How are you doing this now?

Are you using a control script or are you using a GUI tool?
Reply With Quote
  #4 (permalink)  
Old 08-23-10, 15:35
shammat shammat is offline
Registered User
 
Join Date: Nov 2003
Posts: 2,407
Quote:
Originally Posted by VentureFree View Post
I've got a program that's basically just looping through 10,000 some odd rows of calculated data and inserting each one individually into a table on an Oracle 10g database. The server takes a noticeable performance hit when I do this. Is there a more efficient way of inserting 10,000 + records into Oracle at one time? Maybe write to a file and do some kind of bulk insert?
To bulk load text files into the database, use SQL*Loader.

But 10,000 inserts should not bring the server down.
My low-end desktop (dual core 2Ghz, 2GB RAM, regular SATA harddisk) can cope with ~25,000 inserts per second and I can still do queries against the database or read my emails.
There is something in the picture you are not telling us.
Reply With Quote
  #5 (permalink)  
Old 08-26-10, 02:48
NaveenK NaveenK is offline
Registered User
 
Join Date: Aug 2010
Location: Bangalore
Posts: 7
This might be helpful to you

Load Your Data Faster

Explains the different ways of doing bulk inserts in oracle
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On