Re: Possible to dynamically remove hints?

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