Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: OPTIMIZER_INDEX_COST_ADJ & OPTIMIZER_INDEX_CACHING
nirav schreef:
> 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)?
>
By setting your goals.
By measuring.
By changing.
By measuring (again).
Repeat until goal met.
In short: approach it scientifically - no silver bullets here.
-- Regards, Frank van Bortel Top-posting is one way to shut me up...Received on Fri Jun 09 2006 - 13:03:17 CDT