Re: formula for OPTIMIZER_INDEX_COST_ADJ
Date: Thu, 11 Dec 2008 18:24:52 +0000 (UTC)
On Thu, 11 Dec 2008 08:08:00 -0800, Helma wrote:
> 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?Received on Thu Dec 11 2008 - 12:24:52 CST