OraFAQ Forum: Performance Tuning » optimizer_index_cost

Home » RDBMS Server » Performance Tuning » optimizer_index_cost_adj (oracle9i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

optimizer_index_cost_adj [message #323213]

Tue, 27 May 2008 15:16

shrinika
Messages: 306
Registered: April 2008

Senior Member

Dear all,

Can any one help me where exactly i can change the value of this parameter? What would be the value for OLTP and DSS system??

Also can any one explain the purpose of this paramter??

Thanks much..

Report message to a moderator

Re: optimizer_index_cost_adj [message #323215 is a reply to message #323213]

Tue, 27 May 2008 15:31

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Also can any one explain the purpose of this parameter??
let's review.
You don't know what this parameter does, but you are convinced the current value is not optimal & yet you don't know what the new value should be.

Ready, Fire, Aim!

I am glad you can't get close to any database that I care about.

ALL the parameters are documented in the Reference Manual found at http://tahiti.oracle.com

Now go & RTFM!

Report message to a moderator