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

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,

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

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,