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

Thread: Performance of Insert.

Threaded View

  1. 06-07-2011, 08:27 AM #1
    k_17
    k_17 is offline Junior Member
    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width