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