Upgrade from 9.2.0.8 to 11gR2
We are upgrading our Oracle Applications Database from 9.2.0.8 straight to 11.2.0.1. After the running catupgrd.sql there are over 100,000 invalid objects.
Therefore the most appropriate thing to run would be utlrp.sql
I would normally expect utlrp.sql to pick up the number of threads on the box (there are 40 virtual CPU's - as we are using Oracle Sun Ldom technology) but it is not.
Instead there is no degree of parallelism being show and only ONE process is compilng all the invalid objects. This has taken 15 hours and we need to get it down considerably.
Even running exec UTL_RECOMP.recomp_parallel(30); is ignored and only 1 OS level process is used
Therefore the most appropriate thing to run would be utlrp.sql
I would normally expect utlrp.sql to pick up the number of threads on the box (there are 40 virtual CPU's - as we are using Oracle Sun Ldom technology) but it is not.
Instead there is no degree of parallelism being show and only ONE process is compilng all the invalid objects. This has taken 15 hours and we need to get it down considerably.
Even running exec UTL_RECOMP.recomp_parallel(30); is ignored and only 1 OS level process is used
0