RE: Upgrade 8.0 to 8i - Was RE: Wite paper link?

From: Jesse, Rich <Rich.Jesse_at_qtiworld.com>
Date: Fri, 14 Dec 2001 08:55:14 -0800
Message-ID: <F001.003DCCEE.20011214084030@fatcity.com>

I'm thinking that depending on how you're doing the upgrade (migration), your statistics could change, which could obviously change the execution plan. This could happen if you use the export/import method.

You might also want to check out the OPTIMIZER_% init.ora parameters and their defaults for 8i.

Just a thought. When we went from 8.0 to 8.1, we also did RBO->CBO at the same time. So *all* our execution plans changed!

Rich Jesse                          System/Database Administrator
Rich.Jesse_at_qtiworld.com             Quad/Tech International, Sussex, WI USA

-----Original Message-----
Sent: Friday, December 14, 2001 10:15
To: Multiple recipients of list ORACLE-L

Sorry for the subject SNAFU. That's what I get for cut & pasting.

Mike

<SNIP>

List,

We will be upgrading from 806 to 8172 on Tru64 40g/51 next quarter. We did the upgrade on a sandbox system and the process went smoothly. However, my biggest concern is any changes in the CBO. Are these concerns warrented? I was planning on running a series of SQL statements with trace on to compare the CBO under both versions. Any other suggestions to make this upgrade as seamless as possible?

Thanks,
Mike Hand
Polaroid Corp
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Jesse, Rich
INET: Rich.Jesse_at_qtiworld.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Dec 14 2001 - 10:55:14 CST