Skip to Content
author's profile photo
Former Member

Urgent: 46C - ECC6 : PREPARE phases long run times

Hi All

We have Solaris 6.9 64-bit SPARC, Oracle 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.


Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Posted on Aug 21, 2007 at 03:09 PM

    Check the database statistics. Usually the DEV system has the old statistics so Mrs oracle chose the wrong execution path.

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 22, 2007 at 06:23 PM

    First, check if the parameters are set according to

    Note 830576 - Parameter recommendations for Oracle 10g

    especially the "event" section.

    Also check if you have applied all necessary patches for your platform (~ 30 patches):

    Note 871096 - Oracle Database 10g: Patch sets/patches for 10.2.0

    And finally, as suggested by the previous poster, recreate your statistics before you start the upgrade.



    Add comment
    10|10000 characters needed characters exceeded