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

From: Bheemsen Aitha <baitha_at_itradenetwork.com>
Date: Thu, 27 Mar 2014 18:32:35 +0000
Message-ID: <3E9FC3C66B6DD445A50671ECBA1F423EACA642BE_at_plt-exch-01.Itradenetwork.com>

Thanks to everyone for your great inputs. Your replies definitely help me as a starting point.

Thanks
Bheem Aitha

From: Dominic Brooks [mailto:dombrooks_at_hotmail.com] Sent: Thursday, March 27, 2014 2:56 AM
To: Hemant-K.Chitale_at_sc.com
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

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Mar 27 2014 - 19:32:35 CET