Re: 8i to 9i upgrade
- From: Bill Coulam <bcoulam@xxxxxxxxx>
- To: nnahata@xxxxxxxxxxxx
- Date: Thu, 17 Feb 2005 17:25:27 -0600
Our upgrade went smoothly. We researched 9.1 and stopped due to bugs.
A year later, we researched 9.2 and went forward. Of course, the
upgrade was preceded by testing all critical pieces of code on a
mirror database to ensure performance was the same. And the upgrade
process itself was tested and honed on various development and test
instances before preceding with production.
There was a hiccup regarding the older JDBC driver we were using. As I
recall, something about certain NUMBER columns were now being seen by
the driver as BigDecimal, instead of Double, or vice versa. A few
quick fixes to the Java classes though, and we were on our way.
As far as the CBO went, overall, the tests showed most everything
remained performing the same. A few things were 20% to 400% faster.
Two things were dismally slower. One we just couldn't figure out and
added a hint to get the old plan. I think the other we figured out
(can't remember solution).
Once it was in, it opened up numerous 9iR2 features, some of which I'd
been waiting on for 8 years. I guess that's the other advice. Research
enough to know which features and parameters you want to turn on and
implement. That way, they can be tested as well before giving them a
go in production. (SP files, pga_aggregate_target. bulk DML using
records, etc.)
Beyond, that, go straight to 9.2.0.6. Good luck!
On Wed, 16 Feb 2005 19:28:41 -0600, Nahata, Naveen (US - Hyderabad)
<nnahata@xxxxxxxxxxxx> wrote:
> Hi Friends,
> We are planning an upgrade from 8i (8.1.7.4) to 9i on HP-UX platform.
> The database size is close to 500 GB.
>
> I'm looking for best practices, Do's and Don'ts, possible pitfalls and
> alternate strategies for the same.
>
> Please let me know your advice/experience regarding the above.
>
> Regards,
> Naveen
>
> This message (including any attachments) contains confidential information
> intended for a specific individual and purpose, and is protected by law. If
> you are not the intended recipient, you should delete this message. Any
> disclosure, copying, or distribution of this message, or the taking of any
> action based on it, is strictly prohibited.
>
> --
> //www.freelists.org/webpage/oracle-l
>
--
bill coulam
bcoulam@xxxxxxxxx
--
//www.freelists.org/webpage/oracle-l
Other related posts:
