Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2008

    Unanswered: data loading into 9i db slow

    Hi guys

    Just wondering if someone could helpl me speed up the data loading into a 9i database? The method being used is via 'external files'. It's just that the files to load are consistently increasing meaning less files get loaded as compared to the files that come in to load.

    I just wanted to make sure the database is perfectly tuned for this which I know is easier said than done but if, from experience, you know of any parameters to check, please advise? Thanks.

    Sheraz Chowdry

  2. #2
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    If you don't know where time is being spent (where slowdown occurs),
    then you don't know what needs to be fixed to make it faster.

    After you show us where & why the slowdown occurs, then we might be able to make suggestions.
    Until then You're On Your Own.
    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 2008
    OK thanks...Will get more info.

  4. #4
    Join Date
    Jul 2003
    Here is a good test:
    insert X number of rows into the prod table and trace the session or time it or autotrace or whatever.

    create your own identical blank table: create table Y as select * from x where 1=2;
    insert X number of rows into test table Y. trace that.

    See the difference? Notice the difference in waits or buffers, etc?
    What do you think is causing this?

    What is the difference between your test table and the prod table?
    What other objects exist on the prod table? What is happening per insert?

    I could name 5 things to look for but I would rather you test this and figure it out.
    A "table" is not just a table.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  5. #5
    Join Date
    Feb 2006
    Provided Answers: 1

Posting Permissions

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