RE: Warning - 11.2.0.4 upgrade gotcha
- From: Paul Houghton <Paul.Houghton@xxxxxxxxxxxxxxx>
- To: "hemantkchitale@xxxxxxxxx" <hemantkchitale@xxxxxxxxx>, "cdunscombe@xxxxxxxxx" <cdunscombe@xxxxxxxxx>
- Date: Wed, 12 Feb 2014 16:10:23 +0000
The wri$_optstat_histhead_history is not partitioned in our 11.2.0.3 instances,
so presumably it would take time whichever version was being upgraded from.
I note it is partitioned in 12.1, so this will affect us when we upgrade from
11.2.0.3 to 12.1 as we don't intend to go through 11.2.0.4.
Thanks for the heads up.
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Hemant K Chitale
Sent: 12 February 2014 15:47
To: cdunscombe@xxxxxxxxx
Cc: ORACLE-L
Subject: Re: Warning - 11.2.0.4 upgrade gotcha
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<mailto: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
Other related posts:
