RE: optimizer settings

From: Lim, Binley <Binley.Lim_at_NBNZ.CO.NZ>
Date: Tue, 2 Mar 2004 12:12:44 +1300
Message-ID: <5FA85DB5FB07D7118CF50002A5754C0902E2CA02@nbnzhexch2.nbnz.co.nz>

I thought CPU costing is supposed to do that for you, without having to tweak O_I_C_A yourself...?

> -----Original Message-----
> From: K Gopalakrishnan [SMTP:kaygopal_at_yahoo.com]
> Sent: Tuesday, March 02, 2004 3:58 AM
> To: oracle-l_at_freelists.org
> Subject: Re: optimizer settings
>
> Jaffar:
>
> They are the default settings on 9i. You may not need to tweak the max
> permutations
> unless you have more than 7-8 tables in where condition. However you can
> reduce the
> optimizer_index_cost _adj after some analysis on single block read to
> multiblock read
> timings. You can find 'Search for Intelligence in CBO' paper by Tim Gorman
> in his
> site www.evdbt.com
>
>
> Regards,
> Gopal
>
> ----- Original Message -----
> From: "Syed Jaffar Hussain" <sjaffarhussain_at_hotmail.com>
> To: <oracle-l_at_freelists.org>
> Sent: Monday, March 01, 2004 8:12 PM
> Subject: optimizer settings
>
>
> > Hi List,
> >
> > After installing oracle 9.2.0.1 on HPUX 11i bit 64, I found the
> following
> > optimizer settings
> >
> > optimizer_index_cost_adj integer 100
> > optimizer_max_permutations integer 2000
> >
> > Are these parameters set by default to match most of the system
> requirments
> > or do we need to change it?
> >
> > Rgds
> > Jaffar
> -----------------------------------------------------------------

This communication is confidential and may contain privileged material. If you are not the intended recipient you must not use, disclose, copy or retain it. If you have received it in error please immediately notify me by return email and delete the emails.
Thank you.

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 Mon Mar 01 2004 - 17:10:27 CST