RE: Oracle 9i hints that are obsolete in 11gR2

  • From: Bheemsen Aitha <baitha@xxxxxxxxxxxxxxxxx>
  • To: Dominic Brooks <dombrooks@xxxxxxxxxxx>, "Hemant-K.Chitale@xxxxxx" <Hemant-K.Chitale@xxxxxx>
  • Date: Thu, 27 Mar 2014 18:32:35 +0000

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

Other related posts: