Re: Oracle 9i hints that are obsolete in 11gR2
Date: Sun, 30 Mar 2014 19:37:44 +0200
Message-ID: <CA+S=qd0n=rZBYGDFy8chtRjksRkTMYtX9VqDH3KjZhC=QZbPeg_at_mail.gmail.com>
Rule based optimizer stopped working from version 10.1. RULE as OPTIMIZER_MODE gives warning and RULE hint is ignored as there is no longer a rule based optimizer that can follow the old optimizer "rules" ;-)
http://docs.oracle.com/cd/B14117_01/server.101/b10763/compat.htm#sthref318
Regards
Kim Berg Hansen
http://dspsd.blogspot.com
kibeha_at_gmail.com
_at_kibeha
On Sun, Mar 30, 2014 at 5:24 PM, David Roberts < big.dave.roberts_at_googlemail.com> wrote:
> 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-lReceived on Sun Mar 30 2014 - 19:37:44 CEST