Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: OPTIMIZER_INDEX_COST_ADJ & OPTIMIZER_INDEX_CACHING

Re: OPTIMIZER_INDEX_COST_ADJ & OPTIMIZER_INDEX_CACHING

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Fri, 09 Jun 2006 20:03:17 +0200
Message-ID: <e6cd06$m4d$1@news3.zwoll1.ov.home.nl>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US