Re: RBO to CBO

Oradba Linux wrote:

> We are currently running our OLTP System in oracle 9.2.0.4 . We are still
> using RBO . We want to start make using CBO .
> I am reaching out through this forum to find more info on practical
> experiences in this kind of project .
>
> Thanks

Your question is awfully broad.

My short answer based on your ambiguity.

1. Set up a test server
2. Run DBMS_STATS
3. Unhint any hinted code
4. Test
5. Rehint as necessary

Be sure to work through various permutations of the optimizer_index_caching and optimizer_index_cost_adj parameters.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)