Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2014
    Posts
    1

    Unanswered: How to improve performance for large inserts.

    Hi,

    I have to load a table which is partiontioned on a column. Before loading this table, this partition is truncated on a daily basis before loading.

    Data is loaded based on this partition parallely for five partitions through a batch job.

    The problem is time of loading.It takes around 1 hr to load around 1 lakh
    records.

    For other partitions, data count is even higher going upto 10 lakhs.

    The source data involves a lot of calculations also(aggregate functions,joining 3 or 4 tables).

    I have tried using append hint also for direct loading, but that is also not helping.

    Please somebody suggest how i can improve the performance of loading.

    Thanks

  2. #2
    Join Date
    Dec 2007
    Posts
    253
    The source data involves a lot of calculations also(aggregate functions,joining 3 or 4 tables).
    Sounds like this is the bit you need to tune.

Posting Permissions

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