Rule based optimizer stopped working from version 10.1. RULE as OPTIMIZER_MODE gives warning and RULE hint is ignored as there is no longer a rule based optimizer that can follow the old optimizer "rules" ;-) http://docs.oracle.com/cd/B14117_01/server.101/b10763/compat.htm#sthref318 Regards Kim Berg Hansen http://dspsd.blogspot.com kibeha@xxxxxxxxx @kibeha On Sun, Mar 30, 2014 at 5:24 PM, David Roberts < big.dave.roberts@xxxxxxxxxxxxxx> wrote: > I haven't done any investigation to to determine why, but the RULE hint > rarely seems to enhance performance in 11g. > > In a previous role we had a standing rule that rule hints would be removed > by default when upgrading from 9i or 10g to 11g. > > Dave > > > On Thu, Mar 27, 2014 at 6:32 PM, Bheemsen Aitha > <baitha@xxxxxxxxxxxxxxxxx>wrote: > >> Thanks to everyone for your great inputs. Your replies definitely help >> me as a starting point. >> >> >> >> Thanks >> >> *Bheem Aitha* >> >> >> >> *From:* Dominic Brooks [mailto:dombrooks@xxxxxxxxxxx] >> *Sent:* Thursday, March 27, 2014 2:56 AM >> *To:* Hemant-K.Chitale@xxxxxx >> *Cc:* Bheemsen Aitha; ORACLE-L >> *Subject:* Re: Oracle 9i hints that are obsolete in 11gR2 >> >> >> >> Also see V$SQL_HINT for a list of hints. >> >> I don't think it tells you which are deprecated unless that's reflected >> in PROPERTY. >> >> >> >> Interestingly, there is no PARALLEL hint only SHARED which is listed as >> the inverse of NOPARALLEL/NO_PARALLEL >> >> Cheers, >> >> Dominic >> >> >> >> Sent from my iPhone >> >> >> > >