Re: Warning - upgrade gotcha

From: Hemant K Chitale <>
Date: Wed, 12 Feb 2014 23:46:59 +0800
Message-ID: <>

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

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

> Hi all,
> Just in case you've not come across it there's a potential gotcha when
> upgrading to 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 readme doesn't make any reference to this
> Cheers,
> Chris

Received on Wed Feb 12 2014 - 16:46:59 CET

Original text of this message