Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2007
    Posts
    27

    Unanswered: 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?

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    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.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    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?

  4. #4
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    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.

  5. #5
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •