Re: RBO to CBO

• Post for FREE via your newsreader at post.usenet.com ****

> 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

Just a refinement to Daniel's list: run DBMS_STATS to gather object statistics AND system statistics

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

For an OLTP system I'll set OPTIMIZER_MODE to FIRST_ROWS_n (choose n according to your application, usually 10 or 100 is good).

Chris

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

• Usenet.com - The #1 Usenet Newsgroup Service on The Planet! *** http://www.usenet.com Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=