Re: formula for OPTIMIZER_INDEX_COST_ADJ

On Thu, 11 Dec 2008 08:08:00 -0800, Helma wrote:

> Sveiki!
>
> 1) What problem are you trying to solve? Performance problems. A
> previous performance person randomly set some parameters, and i am
> checking if they are correct. One of the init's is this cost_adj
>
> 2) What version of Oracle RDBMS do you work on? Oracle 9.2.05
>
> 3) What platform?
> Unix AIX5.3
>
> 4)How did you get those numbers?
> As said : "(see http://www.evdbt.com/SearchIntelligenceCBO.doc for
> details.)". a select from the system_event
>
> 5) Which version of the DB?
> see 2)
>
> 6) Please give the group the necessary information, when asking
> questions. My ESP abilities
> are a little bit rusty these days.
>
> Compared to David's ESP, yes. ;-)

Have you considered manipulating system statistics, instead of setting the cost adjust?

-- 
http://mgogala.freehostia.com