1 2 Previous Next 22 Replies Latest reply on Dec 21, 2015 6:48 PM by Karthik Appsys

    Increase the Speed of Post Upgrade process - R12 with 12.1.0.2

    Karthik Appsys

      Dear Legends,

       

      We are upgrading a R12.0.6 Database from 10.2.0.5 to 12.1.0.2. using dbua

      - The Pre - upgrade process time is 30 minutes or less

      - The Upgrade process is 2hrs 10 minutes

      - The Post Upgrade is nearly ran for 7-8 hours --> How to reduce this time or speed up this process.

       

      I kept the

      job_queue_process to 1000

      sga - 2G

      pga - 1G

       

      Is there any other parameters required to optimize from Upgrade point of view ?

       

      The Post Upgrade process is doing the INVALIDS and for an hour it is validating nearly 10000 objects. Is there any other way to reduce the downtime. ? 36 Hours is the Max down time I have.

       

      Thanks,

      Karthik

        1 2 Previous Next