Re: Warning - 11.2.0.4 upgrade gotcha
From: Chris Dunscombe <cdunscombe_at_yahoo.com>
Date: Fri, 14 Feb 2014 08:52:10 +0000 (GMT)
Message-ID: <1392367930.53634.YahooMailNeo_at_web28701.mail.ir2.yahoo.com>
Hi, The upgrade was from 11.2.0.3 but I expect it will effect any upgrade to 11.2.0.4 and also any upgrade to 12c from a version prior to 11.2.0.4. Cheers, Chris On Wednesday, 12 February 2014, 15:48, Hemant K Chitale <hemantkchitale_at_gmail.com> wrote: 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
Date: Fri, 14 Feb 2014 08:52:10 +0000 (GMT)
Message-ID: <1392367930.53634.YahooMailNeo_at_web28701.mail.ir2.yahoo.com>
Hi, The upgrade was from 11.2.0.3 but I expect it will effect any upgrade to 11.2.0.4 and also any upgrade to 12c from a version prior to 11.2.0.4. Cheers, Chris On Wednesday, 12 February 2014, 15:48, Hemant K Chitale <hemantkchitale_at_gmail.com> wrote: 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-lReceived on Fri Feb 14 2014 - 09:52:10 CET