DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Performance of Insert.

  1. #1
    Join Date
    Jun 2011
    Posts
    2

    Performance of Insert.

    Hi all,

    This is my first post in the forum, i am posting all the details i can, if anything is missing please let me know.

    DB Version :- 10.1.0.5.0

    Attached is the insert which takes long time to execute. As it big I am attaching it.

    Can anyone please let me know as how we can reduce the run time of the insert. Its inserting data into partitioned table (390 partitons). First Trunacting the table and then perform insert.

    Regards,
    K_17
    Attached Files Attached Files

  2. #2
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    you are talking about Insert but attached a select statement. bit confused.

    How is the insert happening? Through application or explicit insert statement?

    Any Indexes on the table being insert?

    Thanks,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

  3. #3
    Join Date
    Jun 2011
    Posts
    2
    Sorry Vijay,

    Its insert into ABC (column..names....) select .....

    Insert is happening as script scheduled to run [explicit insert]. And there are no index on this table.table is partitioned.

    Regards,
    K_17

  4. #4
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    Okay.

    In the select query it seems object level parallelism is enabled on RHS_PREMIUM_1 table. Not sure how much it is. It is always preferable to use parallel hint rather than object level degree. Please check and increase the parallel threads.

    Also as you are doing conditional insert, please check if you can use partition column to get partition elimination advantage (for RHS_PREMIUM_1 table).

    As the target table is truncate and load use 'append' hint along with parallel hint. Also, make sure target table is in nologging.

    Thanks,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

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