RE: 8i to 9i upgrade

From: Loughmiller, Greg <greg.loughmiller_at_cingular.com>
Date: Thu, 17 Feb 2005 07:42:48 -0600
Message-ID: <5164A49467308C45AD50661F8CFDC3431E11C578@s30342g004004.wdc.cingular.net>

I would concur with Guang!
Test test test

The optimizer changes in every release. And there can be significant changes in the execution plan of SQL. And there may be the need to establish some different values for the init parameters based on your testing........

greg

-----Original Message-----

From: Guang Mei [mailto:GMei_at_ph.com]
Sent: Thursday, February 17, 2005 8:09 AM To: 'nnahata_at_deloitte.com'; oracle-l_at_freelists.org Subject: RE: 8i to 9i upgrade

I would say to fully test your applications on your test 9i system before you migrate. Some sql query plan can change due to oracle's internal optmizer change. Also I would use oracle exp/imp to move schema data.

HTH. Guang

-----Original Message-----

From: Nahata, Naveen (US - Hyderabad) [mailto:nnahata_at_deloitte.com] Sent: Wednesday, February 16, 2005 8:29 PM To: oracle-l_at_freelists.org
Subject: 8i to 9i upgrade

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.

--

http://www.freelists.org/webpage/oracle-l

PRIVILEGED AND CONFIDENTIAL:
This communication, including attachments, is for the exclusive use of addressee and may contain proprietary, confidential and/or privileged information. If you are not the intended recipient, any use, copying, disclosure, dissemination or distribution is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return e-mail, delete this communication and destroy all copies.

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Thu Feb 17 2005 - 08:46:14 CST