OraFAQ Forum: Performance Tuning » OPTIMIZER_INDEX_COST_ADJ & OPTIMIZER_INDEX

Home » RDBMS Server » Performance Tuning » OPTIMIZER_INDEX_COST_ADJ & OPTIMIZER_INDEX_CACHING

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

OPTIMIZER_INDEX_COST_ADJ & OPTIMIZER_INDEX_CACHING [message #176770]

Fri, 09 June 2006 09:05

orausern
Messages: 826
Registered: December 2005

Senior Member

Hi,

I have both of these parameters . set at their default values in my db. (100 & 0 respectively.) That however might not be the correct setting , so could you please guide on how to decide the correct setting for these parameters for the database(version 9.2.0.6)?

Report message to a moderator

Re: OPTIMIZER_INDEX_COST_ADJ & OPTIMIZER_INDEX_CACHING [message #176772 is a reply to message #176770]

Fri, 09 June 2006 09:20

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

http://www.evdbt.com/papers.htm
Look for article
The Search for Intelligent Life in the Cost-Based Optimizer

Report message to a moderator

Re: OPTIMIZER_INDEX_COST_ADJ & OPTIMIZER_INDEX_CACHING [message #176776 is a reply to message #176772]

Fri, 09 June 2006 09:28

orausern
Messages: 826
Registered: December 2005

Senior Member

Thank you very much! there are so many useful papers there.. I shall go through this and try to understand the parameter values..

Report message to a moderator

Previous Topic:	PL/SQL code review tool
Next Topic:	database slow

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 01 01:17:25 CDT 2024