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@xxxxxxxxx> 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 >