Re: performance in 10g

From: Dennis Williams <oracledba.williams_at_gmail.com>
Date: Thu, 29 Mar 2007 12:57:06 -0500
Message-ID: <de807caa0703291057i484468f4m2db4eba65282ad7e@mail.gmail.com>

Dave,

Okay if I'm understanding you correctly, you made two changes at once:

Upgraded from 9i to 10g.
Switched from RBO to CBO. Have I understood you correctly? It may be difficult to separate what is caused by each change. There have been some good papers describing the steps to take in the RBO -> CBO migration. Yesterday someone posted a link to the Oracle White Paper Migrating to the Cost-Based Optimizer. Did you see that (maybe they posted it in response to your question).

Dennis Williams

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

Received on Thu Mar 29 2007 - 12:57:06 CDT