Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Possible to dynamically remove hints?

RE: Possible to dynamically remove hints?

From: Jesse, Rich <>
Date: Thu, 10 Apr 2003 12:24:05 -0800
Message-ID: <>

Yup, I originally wanted to use CS=F, but not on, which is what is installed by the vendor's install. No, I take that back -- Oracle is not installed; it is copied to disk. Since it isn't installed with the Oracle Installer, it's also not patchable to, which is the minimum version I'm comfortable with for CS=F, due to some of those nasty side effects you referenced (e.g. wrong data returned in specific queries, etc).

And yes while most of the query would be static, the number of items in the IN clause would vary greatly. And I don't think creating over 1300 plans is the answer... :)


Rich Jesse                        System/Database Administrator           Quad/Tech International, Sussex, WI USA

-----Original Message-----
Sent: Thursday, April 10, 2003 1:34 PM
To: Multiple recipients of list ORACLE-L

The only way I can think of to override the hint - deleting all statistics won't help because the hint forces the CBO in any case (unless the hint happens to be rule of course) - is with a stored outline, but for that to work the sql has to use bind variables (so that the hash value doesn't change for different executions) and from your description of the problem I doubt that that is the case. If you are desperate you can try cursor_sharing=force and see if you then can use stored outlines, but cursor_sharing force can have nasty sideeffects.

Please see the official ORACLE-L FAQ:

Author: Jesse, Rich

Fat City Network Services    -- 858-538-5051
San Diego, California        -- Mailing list and web hosting services
To REMOVE yourself from this mailing list, send an E-Mail message to: (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 - 15:24:05 CDT

Original text of this message