Re: Oracle Apps Upgrade from to R12.1.1

From: Riyaj Shamsudeen <>
Date: Thu, 8 Mar 2012 09:12:27 -0600
Message-ID: <>

Hello Bala
  In addition to John's comments, have you reviewed the SQL file to see what's causing the slowness?. In numerous cases, I have seen that custom indexes on few columns causing DML statements slowness or even triggers on tables, causing slower upgrade process. So, you might want to review AWR report during that time frame, identify the SQL statement to see if it is suffering from any such ill effects.
  Number of workers matter too. Too many can cause excessive buffer busy waits and too few may not be optimal.


Riyaj Shamsudeen
Principal DBA,
Ora!nternals - - Specialists in Performance, RAC and EBS
OakTable member and Oracle ACE Director

Co-author of the books: Expert Oracle
Practices<>, Pro Oracle SQL, Expert PL/SQL

Join me for next RAC training in March


On Wed, Mar 7, 2012 at 11:47 PM, Bala krishna <> wrote:

> Hi All,
> We've have upgraded Oracle apps from to R12.1.1 and then to
> R12.1.3 during the upgrade appdstln.sql ran almost 17 hours and took more
> than 150GB of space and in the mean time we've also added 40GB undo
> tablespace too but even then at last it errrored with undo tablespace .
> Looks like the above script is doing very bad and finally we'd to skip that
> sql and continue with the upgrade . I've got few questions can anybody
> answer inase if they'd experienced please.
> We've raised SR with Oracle support but so far we've not got any solution
> yet, rather than asking too many questions and its more than 2 weeks :(
> My Questions:-
> 1. As per our plan we wanted to upgrade from R12.1.1 to 12.1.3 during this
> upgrade appdstln.sql finished sucessfully but it took almost 3 hours during
> that time . Do you still think that i need to re-run this script since i've
> skipped during R12.1.1 upgrade from 11i.
> 2. Since we've already skipped appdstln.sql can we re-run the script after
> the upgrade if yes what is the procedure.
> 3. For next upgrade does any body of you have any suggestions to make the
> script run faster ?
> Thanks
> Bala
> --

Received on Thu Mar 08 2012 - 09:12:27 CST

Original text of this message