Upgrade from 11.5.10cu2 to R12.1.1 : u667700.drv : Following sqls take long time to complete. cs
Hi ,
We had couple of rounds of test upgrade from 11i to R12.1.1 . During the iteration, we found the following sql's are taking long time to complete
cstpostimportaad.sql 8hrs 45 min
appostimportaad.sql 7 hrs
papostimportaad.sql 4 hours
arpostimportaad.sql 2hrs 15 mins
Can you please suggest any workarounds to improve the performance of these scripts.
Thanks
Ram
We had couple of rounds of test upgrade from 11i to R12.1.1 . During the iteration, we found the following sql's are taking long time to complete
cstpostimportaad.sql 8hrs 45 min
appostimportaad.sql 7 hrs
papostimportaad.sql 4 hours
arpostimportaad.sql 2hrs 15 mins
Can you please suggest any workarounds to improve the performance of these scripts.
Thanks
Ram
Tagged:
0