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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Re: optimizer_index_cost_adj and optimizer_index_caching

Re: Re: optimizer_index_cost_adj and optimizer_index_caching

From: <ryan.gaffuri_at_cox.net>
Date: Tue, 9 Mar 2004 8:36:31 -0500
Message-Id: <20040309133631.FVAR10652.lakemtao04.cox.net@smtp.east.cox.net>


the debate on this topic is exactly why we need to keep this list going. Thanks for all your help guys.
>
> From: "Juan Cachito Reyes Pacheco" <jreyes_at_dazasoftware.com>
> Date: 2004/03/09 Tue AM 08:19:01 EST
> To: <oracle-l_at_freelists.org>
> Subject: Re: optimizer_index_cost_adj and optimizer_index_caching
>
> I'm using, because in a specific database a query gave trouble, and I fixed
> it setting this parameters. Curiously in other production databases (more
> than 15) similar to that, didn't gave that problem.
> But we decided to set it any way.
> I think is better to set them, even when in most situation there is not
> problems.
> :)
>
> ----- Original Message -----
> From: "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk>
> To: <oracle-l_at_freelists.org>
> Sent: Tuesday, March 09, 2004 5:01 AM
> Subject: RE: optimizer_index_cost_adj and optimizer_index_caching
>
>
> Thanks Joze and Wolfgang
>
> I'm in a position where gathering system stats seems to me to be the Right
> Thing (tm) to do, certainly an advance on setting parameters based on
> guesses/measurements ahead of time. I hadn't until now seen any indications
> as to whether the feature worked as advertised or if in fact gathering
> system stats introduced for example unexpected and unwanted plan changes,
> curious bugs etc etc. In fact I hadn't seen *any* feedback at all which made
> me suspicious that anyone was actually using it - I guess folks recall the
> introduction of the CBO which was equally the right thing to do but..
>
> Niall Litchfield
> Oracle DBA
> Audit Commission
> +44 117 975 7805
>
>
>
> **********************************************************************
> This email contains information intended for
> the addressee only. It may be confidential
> and may be the subject of legal and/or
> professional privilege. Any dissemination,
> distribution, copyright or use of this
> communication without prior permission of
> the sender is strictly prohibited.
> **********************************************************************
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>



Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Tue Mar 09 2004 - 07:34:55 CST

Original text of this message

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