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 [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
