Re: Re: optimizer_index_cost_adj and optimizer_index_caching
- From: <ryan.gaffuri@xxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 9 Mar 2004 8:36:31 -0500
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@xxxxxxxxxxxxxxxx>
> Date: 2004/03/09 Tue AM 08:19:01 EST
> To: <oracle-l@xxxxxxxxxxxxx>
> 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@xxxxxxxxxxxxxxxxxxxxxxx>
> To: <oracle-l@xxxxxxxxxxxxx>
> 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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
