Results 1 to 3 of 3
  1. #1
    Join Date
    May 2004
    Location
    Pune, India
    Posts
    15

    Unanswered: Loading data into Oracle FASTER

    hi,

    I want to insert some n rows(lacs of rows) into Oracle schema. The data is existing in a particular format. Those lines wud be read by a function in C and then this functino wud be inserting data into the concerned table. The data will be inserted in some specific tables - say 25 tables.

    The problem is that its taking tooooo long when we increase the number of rows in hte file. The format of the data is in TCN.

    Is there any thing we can do to increase performance?? So that we can have the data being INSERTed into teh tables in a faster manner.

    The indexes adn constraints are disabled at hte time of insertion.

    Does it have anything to do with the init and next extent size??
    Does it have anything to do wiht rollback segemnts?? M using oracle 9.2 rel.

    Pls help
    thanks in advance

    regards
    Ms. Abhivyakti

  2. #2
    Join Date
    Aug 2004
    Posts
    19
    Why don't you use sqlldr to load the data into one temp table and write DB-procedure to distribute to other tables depending on your logic.... Ofcourse, you have to consider turning off constraints and indexes...Please check 9i's temp. table and direct path option in sqlldr.

    Jagannath

  3. #3
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    The file can be directly accessed by SQL and/or PL/SQL if it is configured to be an external table.

    The only 100% SURE way to know why the load takes a "long" time, is to enable SQL_TRACE & run the resultant trace file thru TKPROF.
    Otherwise you are just guessing and shooting blindly into the darkness.
    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.

Posting Permissions

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