Home » RDBMS Server » Performance Tuning » optimizer_index_cost_adj (oracle9i)
optimizer_index_cost_adj [message #323213] Tue, 27 May 2008 15:16 Go to next message
shrinika
Messages: 267
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..
Re: optimizer_index_cost_adj [message #323215 is a reply to message #323213] Tue, 27 May 2008 15:31 Go to previous messageGo to next message
BlackSwan
Messages: 25050
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!
Re: optimizer_index_cost_adj [message #323430 is a reply to message #323213] Wed, 28 May 2008 08:14 Go to previous messageGo to next message
Rajabaskar Thangaraj
Messages: 13
Registered: March 2008
Location: CHENNAI
Junior Member


http://oracleact.com/papers/optimizer_index_caching.html


Regards
RajaBaskar

Re: optimizer_index_cost_adj [message #323474 is a reply to message #323430] Wed, 28 May 2008 09:44 Go to previous message
shrinika
Messages: 267
Registered: April 2008
Senior Member
Thanks Rajabaskar.
Previous Topic: performance issue
Next Topic: Tuning need for a large data
Goto Forum:
  


Current Time: Sat Dec 10 06:38:05 CST 2016

Total time taken to generate the page: 0.08041 seconds