Home » RDBMS Server » Performance Tuning » RBO to CBO migration (Oracle 9i)
RBO to CBO migration [message #298501] Wed, 06 February 2008 04:26 Go to next message
sairajesh
Messages: 7
Registered: April 2007
Junior Member
Hi Guys,

Currently i am using oracle 9i Release 2 & Rule based Optimizer .I'm planning to migrate to Cost based optimizer .Can any one help...

1) what are the steps i should follow.
2) Is their any performance degradation in any of Sql statements(I knew CBO would work better than RBO)But Still..
3)which parameters we should consider.

My DB is OLTP type & size of the DB is 500 GB Size...

Kindly share knowledge, so it will help to me..
Re: RBO to CBO migration [message #298514 is a reply to message #298501] Wed, 06 February 2008 04:46 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1) change optimizer_goal to choose
2) It may happen
3) None and all optimizer related one. You above all have to consider the queries.

Regards
Michel
Previous Topic: Deletion records - Performance
Next Topic: Dictionary_cache = 0 ?
Goto Forum:
  


Current Time: Thu Dec 08 08:22:24 CST 2016

Total time taken to generate the page: 0.04777 seconds