Re: Warning - 11.2.0.4 upgrade gotcha

From: Hemant K Chitale <hemantkchitale_at_gmail.com>
Date: Wed, 12 Feb 2014 23:46:59 +0800
Message-ID: <CAMNBsZt-xKVF3wt7OLAbFiaM2quz=r4PzTAuvwY6NHgfEHntwQ_at_mail.gmail.com>



And we tell our customers / managers that upgrade duration is not related to the volume (size of the database). Was this upgrade from 10.2 or 11.2 ?

Hemant K Chitale
http://hemantoracledba.blogspot.com

On Feb 12, 2014 11:36 PM, "Chris Dunscombe" <cdunscombe_at_yahoo.com> wrote:

> Hi all,
>
> Just in case you've not come across it there's a potential gotcha when
> upgrading to 11.2.0.4. We hit it a couple of weeks ago and I believe it
> affects all platforms.
>
> The issue is caused by the database upgrade script, catupgrd.sql,
> partitioning the statistics history tables, wri$_optstat_histhead_history
> etc. So if you've got a lot of data in these tables, either because you're
> keeping a lot of history or the automatic purge job (runs in the
> maintenance window) isn't clearing the data down, then the partitioning
> can take many hours and hence the upgrade takes many hours.
>
> The exact time all depends on your hardware and the amount of data in
> these history tables. Generally the biggest table is wri$_optstat_histhead_history.
> The 11.2.0.4 readme doesn't make any reference to this
>
> HTH
>
> Cheers,
>
> Chris
>

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Feb 12 2014 - 16:46:59 CET

Original text of this message