Re: formula for OPTIMIZER_INDEX_COST_ADJ
Date: Thu, 11 Dec 2008 08:08:00 -0800 (PST)
- 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
- What version of Oracle RDBMS do you work on? Oracle 9.2.05
- 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?
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. ;-) Received on Thu Dec 11 2008 - 10:08:00 CST