SQL Performance (MOSC)

MOSC Banner

Is there any way to disable "+ RULE" hint in Oracle 11gR2

edited Mar 6, 2017 12:22PM in SQL Performance (MOSC) 6 commentsAnswered

I have a vendor-written application that is creating SQL statements with the "+ RULE" hint.

Is there any way to disable use of the "+ RULE" hint so the CBO will be used?

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Automatic Storage Management option

optimizer_features_enable = 11.2.0.4

optimizer_mode = ALL_ROWS

SELECT   /*+ RULE */

         DISTINCT

         n.ITEMNAME,

         v.ITEMOBJID,

         v.ITEMTYPE,

         v.VERSIONOBJID,

         v.PACKAGEOBJID,

         v.PARENTVERSIONID,

         v.MERGEDVERSIONID,

         v.MAPPEDVERSION,

         v.VERSIONSTATUS,

         v.INBRANCH,

         p.PACKAGENAME,

         v.CREATIONTIME,

         v.CREATORID,

         v.DESCRIPTION,

         v.VERSIONDATAOBJID,

         v.CLIENTMACHINE,

         v.CLIENTPATH,

         u2.USERNAME                      CREATORNAME,

         u1.USERNAME                      MODIFIERNAME,

         v.MODIFIERID,

         v.MODIFIEDTIME,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center