Re: Oracle Apps Upgrade from to R12.1.1

  • From: Riyaj Shamsudeen <riyaj.shamsudeen@xxxxxxxxx>
  • To: krishna000@xxxxxxxxx
  • Date: Thu, 8 Mar 2012 09:12:27 -0600

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,
OakTable member and Oracle ACE Director

Co-author of the books: Expert Oracle
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 <krishna000@xxxxxxxxx> 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
> --


Other related posts: