Re: performance in 10g

From: "Dennis Williams" <oracledba.williams@xxxxxxxxx>
To: zhuchao@xxxxxxxxx
Date: Thu, 29 Mar 2007 12:57:06 -0500

Dave,

Okay if I'm understanding you correctly, you made two changes at once:
  1. Upgraded from 9i to 10g.
  2. 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

References:

RE: performance in 10g
From: Govind.Arumugam

Re: performance in 10g
From: Zhu,Chao

Re: performance in 10g

Other related posts: