RE: optimizer parameters in Oracle 9.2

For the ignorant, what is 10G?

v/r

Stephen S. Wolfe, GS-11, DAFC
Data Services Manager
stephen.wolfe_at_macdill.af.mil
(813) 827-9974 DSN 651-9974
> -----Original Message-----
> From: Tim Gorman [mailto:tim_at_sagelogix.com]
> Sent: Wednesday, July 30, 2003 12:30 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: optimizer parameters in Oracle 9.2
>
>
> 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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Wolfe Stephen S GS-11 6 MDSS/SGSI
  INET: Stephen.Wolfe_at_macdill.af.mil

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).