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

From: David Roberts <big.dave.roberts_at_googlemail.com>
Date: Sun, 30 Mar 2014 16:24:41 +0100
Message-ID: <CAOCOAVLdmqVhgtgCKfimL6Y0hHAV9JhMDnw3ngQ_FJfRBD=RTg_at_mail.gmail.com>

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_at_itradenetwork.com>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_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 Sun Mar 30 2014 - 17:24:41 CEST