| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: optimizer parameters in Oracle 9.2
Tim,
I noticed that, but still it is a great article and I'm looking forward to reading the updated version
thanks for your help
Gene
--- Tim Gorman <tim_at_sagelogix.com> wrote:
> 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
> >>
> >
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gurelei INET: gurelei_at_yahoo.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 - 12:29:36 CDT
 |
 |