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.
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.