Urgent: 46C - ECC6 : PREPARE phases long run times
We have Solaris 6.9 64-bit SPARC, Oracle 10.2.0.2. Upgrading the 4.6C to ECC 6.0 SR2. Iam running the PREPARE on the DEV system. There was a sandbox (copy of production) system upgraded recently.
The DEV prepare phases are taking very long time to finish, but are successful. Like the PREPARE phase ADJ_CNTRANS took 1 hour on DEV, where it took only 27 minutes on Sandbox.
And the batch job for this phase only has 3 lines in the logs
> job started
> report name user id ddic
> job finished
And the phase TOOLIMPI took 2 hours on DEV, whereas it took only 16 minutes on Sandbox. Its pretty much taking twice as much of sandbox phase time on dev system, for some phases.
Iam not able to figure where is it getting help up. The sm50 processes are all waiting, 8 CPUs 96% of idle time, 5G ram.