Please be aware that the paper and presentation were written in the 8i
timeframe. I swear I'll get it updated for 9i, but already 10G is looming
and it's summer and the weather is nice........<sigh>...
on 7/30/03 8:24 AM, Gurelei at gurelei_at_yahoo.com wrote:
> Rich,
>
> thanks a lot. I just finished reading Tim's paper and
> it is truly enjoyable reading. I'm going to test his
> advices in a few moments.
>
> Gene
> --- "Jesse, Rich" <Rich.Jesse_at_qtiworld.com> wrote:
>> Paging Mr. Gorman....Mr. Tim Gorman...
>>
>> I had wonderful luck with Tim's paper "The Search
>> for Intelligent Life in
>> the Cost-Based Optimizer" from:
>> http://www.evdbt.com/papers.htm
>>
>> Enjoy! (And thanks again, Tim!)
>>
>> Rich
>>
>> Rich Jesse System/Database
>> Administrator
>> rjesse_at_qtiworld.com Quad/Tech Inc,
>> Sussex, WI USA
>>
>>
>>> -----Original Message-----
>>> From: Gurelei [mailto:gurelei_at_yahoo.com]
>>> Sent: Wednesday, July 30, 2003 9:04 AM
>>> To: Multiple recipients of list ORACLE-L
>>> Subject: optimizer parameters in Oracle 9.2
>>>
>>>
>>> Hi all:
>>>
>>> I have been reading on the optimizer_ parameters
>> for
>>> Oracle 9i - optimizer_max_permutation,
>>> optimizer_index_caching and
>> optimizer_index_cost_adj.
>>> I have also been playing whith them and I can see
>> that
>>> they affect the explain plans for some queries
>> quite
>>> dramatically. Is there any guidelines for what
>> they
>>> should be set to for optimum performance (some
>> kind of
>>> range and may be relationship between the values)
>> or
>>> is this mostly a trial and error kind of thing? I
>> have
>>> seen a few discussion on the Oracle Metalink, but
>>> mostly they are very specific - try this value or
>> try
>>> that value. Does anyone have a link to a document
>> with
>>> something more systematic than that?
>>>
>>>
>>> thank you
>>>
>>> Gene
>> --
>> Please see the official ORACLE-L FAQ:
>> http://www.orafaq.net
>> --
>> Author: Jesse, Rich
>> INET: Rich.Jesse_at_qtiworld.com
>>
>> Fat City Network Services -- 858-538-5051
>> http://www.fatcity.com
>> San Diego, California -- Mailing list and web
>> hosting services
>>
> ---------------------------------------------------------------------
>> To REMOVE yourself from this mailing list, send an
>> E-Mail message
>> to: ListGuru_at_fatcity.com (note EXACT spelling of
>> 'ListGuru') and in
>> the message BODY, include a line containing: UNSUB
>> ORACLE-L
>> (or the name of mailing list you want to be removed
>> from). You may
>> also send the HELP command for other information
>> (like subscribing).
>
>
> __________________________________
> Do you Yahoo!?
> Yahoo! SiteBuilder - Free, easy-to-use web site design software
> http://sitebuilder.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Tim Gorman
INET: tim_at_sagelogix.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Wed Jul 30 2003 - 11:29:31 CDT
