Re: optimizer settings

From: K Gopalakrishnan <kaygopal_at_yahoo.com>
Date: Mon, 1 Mar 2004 20:27:55 +0530
Message-ID: <002801c3ff9d$986f3880$0200010a@idc.oracle.com>

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
>
> ----------------------------------------------------------------
> 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 Mon Mar 01 2004 - 08:59:57 CST