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.



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?

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).

Search Discussions

Discussion Posts


Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 2 of 3 | next ›
Discussion Overview
grouporacle-l @
postedDec 14, '01 at 4:43p
activeDec 14, '01 at 8:12p



site design / logo © 2022 Grokbase