Home » RDBMS Server » Performance Tuning » OPTIMIZER_INDEX_COST_ADJ & OPTIMIZER_INDEX_CACHING
OPTIMIZER_INDEX_COST_ADJ & OPTIMIZER_INDEX_CACHING [message #176770] Fri, 09 June 2006 09:05 Go to next message
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 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
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 Go to previous message
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Apr 19 22:01:22 CDT 2026
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.