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