RE: Wite paper link?
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: Hand, Michael T 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).
Upgrade 8.0 to 8i - Was RE: Wite paper link?
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: Hand, Michael T 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).
RE: Upgrade 8.0 to 8i - Was RE: Wite paper link?
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).
RE: Upgrade 8.0 to 8i - Was RE: Wite paper link?
Michael - We did this upgrade on Compaq Tru64 and experienced no CBO hitches (or other hitches). Is there something in particular that raises your CBO concern? Are you on RBO now? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, December 14, 2001 10:15 AM 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: Hand, Michael T 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS 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).
Re: Wite paper link?
Thanks. On 01 Aug 2001 14:30:40 -0800, Suzy Vordos wrote: http://www.quest.com/whitepapers/index.asp Rodd Holman wrote: Does anyone know of a link to Gaja's wite paper on tuning that he presented at OOW 2000? I'm running into some fun tuning thins and I can't seem to find my notes from the session. TIA Rodd Holman [EMAIL PROTECTED] -- Author: Suzy Vordos INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodd Holman 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).
Re: Wite paper link?
http://www.quest.com/whitepapers/index.asp Rodd Holman wrote: Does anyone know of a link to Gaja's wite paper on tuning that he presented at OOW 2000? I'm running into some fun tuning thins and I can't seem to find my notes from the session. TIA Rodd Holman [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodd Holman 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Suzy Vordos 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).