Hello -
 
Has anyone encountered speed issues running the DMU for TMS 2010?
 
We have run through the entire upgrade process twice so far on our test database, and some of the tasks are taking a very long time.  Specifically the following two DMU tasks are taking the longest:
Populate Object Attribution Field = 43 hours
Merge Loan-Related Roles = 23 hrs
 
End to end, the entire upgrade process (scripts, updateDD, DMU, etc) is taking ~75 hours.  I understand that the DMU will respond differently given your dataset, but our record set is relatively small.  The Object Attribution process looks to be inserting 300k records into the ConXrefSets table, which isn't that many, but each one sets off 3 triggers, so that adds to the overhead.  Still, it shouldn't be taking that long.
 
We are on Oracle 10.2.0.4.
 
Please let me know if you have had similar experiences and especially if you have any suggestions on how I can combat it.
 
Thanks,
Rebecca
 
Rebecca Ronsaville
Software Engineer
J Paul Getty Museum
[log in to unmask]
310-440-6075