RE: optimizer settings
- From: "Lim, Binley" <Binley.Lim@xxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 2 Mar 2004 12:12:44 +1300
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@xxxxxxxxx]
> Sent: Tuesday, March 02, 2004 3:58 AM
> To: oracle-l@xxxxxxxxxxxxx
> 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@xxxxxxxxxxx>
> To: <oracle-l@xxxxxxxxxxxxx>
> 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@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:
