How about CURSOR_SHARING_EXACT ?
(not to remove hints, but in relation to not kicking
in CBO)
Cheers
Connor
- Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
wrote: >
> Sounds like a job for:
> optimizer_features_enable=6.0.27
> to me.
>
> Humour aside, I only dropped in on this thread
> to mention that Steve Adams has found a couple
> of other hints that don't cause the CBO to kick in.
> One of them was UNNEST, and I can't remember
> the other.
>
> Regards
>
> Jonathan Lewis
> http://www.jlcomp.demon.co.uk
>
> The educated person is not the person
> who can answer the questions, but the
> person who can question the answers -- T. Schick
> Jr
>
>
> One-day tutorials:
> http://www.jlcomp.demon.co.uk/tutorial.html
>
> ____UK_______April 22nd
> ____Denmark__May 21-23rd
> ____USA_(FL)_May 2nd
>
> Three-day seminar:
> see http://www.jlcomp.demon.co.uk/seminar.html
> ____UK_(Manchester)_May
> ____Estonia___June (provisional)
> ____Australia_June (provisional)
> ____USA_(CA, TX)_August
>
> The Co-operative Oracle Users' FAQ
> http://www.jlcomp.demon.co.uk/faq/ind_faq.html
>
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L"
> <ORACLE-L_at_fatcity.com>
> Sent: 10 April 2003 19:33
>
>
> > Rich:
> >
> > You can not remove or disable hints. There are
> some enhancement
> > requests pending with Oracle asking for events or
> parameters
> > to disable the hints. If your hints are
> independent hints
> > then you are left with no choice other than living
> with that.
> >
> > If the hints are dependent on object names you can
> try renaming
> > the objects (like renaming the index, etc) if they
> are referred
> > as those names in the indexes. If they are
> standard-independent
> > hints like ORDERED you can not do anything.
> >
> > BTW removing the statistics will not force the
> RULE optimizer.
> > As soon as the kernel sees the HINTS it
> automatically invokes
> > the CBO (with the single exception of RULE hint)
> and uses the
> > default statistics or calculates the stats from
> the segment
> > headers.
> >
> > Best Regards,
> > K Gopalakrishnan
> >
>
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> --
> Author: Jonathan Lewis
> INET: jonathan_at_jlcomp.demon.co.uk
>
> 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).
>
Connor McDonald
web:
http://www.oracledba.co.uk
web:
http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com
"GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day"
Yahoo! Plus
For a better Internet experience
http://www.yahoo.co.uk/btoffer
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: =?iso-8859-1?q?Connor=20McDonald?=
INET: hamcdc_at_yahoo.co.uk
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 Thu Apr 10 2003 - 21:38:36 CDT
