This content has been marked as final. Show 4 replies
I found that the initialization parameter in my DB was not set properly. I have changed the following initialization parameter which is a dynamic parameter and the table split step completed in just 1 minute.
optimizer_features_enable = 10.2.0.5
My database was 10.2.0.5 and the value for optimizer_features_enable was set to 9.2.0
Becasue of this parameter the explain plan went for nested loop query rather than going for Hash join.
This caused the performance issue and costed me 8 hrs to calculate the table split threashold.
Now after changing the value the DMU conversion is really fast.