perf. prob during load from sqlldr
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: perf. prob during load from sqlldr

  1. #1
    Join Date
    Jan 2001
    Posts
    230

    Question

    I have a table which is partitioned by month. We keep last few months of records and delete others (drop partition...)

    We are using sqlldr to load the data into table.

    Intially this table had global index due to the perf. problem we changed it to local index.

    Now during the load I want to disable or drop the local index for one of the partition which is going to use during the load so it can improve the perf during the load.

    Any suggestion?

    Thanks

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    do you use direct load? direct=y

  3. #3
    Join Date
    Jan 2001
    Posts
    230
    Pando:

    I tried with direct=true option and it hangs. Do I need to set up anything else?

    Let me know.

    Thanks.

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    has the table got special datatypes such as LOBs?

  5. #5
    Join Date
    Jan 2001
    Posts
    230
    No special data type.

    Any suggestion?

    Thanks.

  6. #6
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    well I dont know why it hangs then, that has never happened to me. you sure your control file and parameters are correct

  7. #7
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    I would try dropping the index before the load and recreate it after the load. Then set the direct=true.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  8. #8
    Join Date
    Jan 2001
    Posts
    230
    Controlfile and other parameters are set correctly. We ran before without adding DIRECT=TRUE and worked fine.

    also, instead of dropping the index, if I disable the index, load the data with direct=true enable/rebuild the index, will it work?

    Thanks.

  9. #9
    Join Date
    Jan 2001
    Posts
    230
    Hi:

    I was able to load the data with the direct=true and Performance was improved.

    During the load direct=true, disabled all the indexes including PK index.

    That allowed to insert the multiple rows with the same PK.

    Now, problem with enabling the PK and Data integrity.

    Now, I am thinking to disable all the indexex accept PK index.

    I would like to know that how can I diable the locally partitioned index or any other suggestion.

    Thank.


  10. #10
    Join Date
    Jan 2001
    Posts
    230
    Hi:

    Diff. between DISABLE and UNUSABLE?
    Instead of using disable, can I use UNUSABLE?

    Thanks.

Posting Permissions

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


Click Here to Expand Forum to Full Width