| 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: Possible to dynamically remove hints?
Yup, I originally wanted to use CS=F, but not on 8.1.7.2.0, 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 8.1.7.4.0, 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... :)
Thanks,
Rich
Rich Jesse System/Database Administrator rich.jesse_at_qtiworld.com 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: 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). Received on Thu Apr 10 2003 - 15:24:05 CDT
 |
 |