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

From: Sayan Malakshinov <xt.and.r_at_gmail.com>
Date: Sun, 30 Mar 2014 22:05:25 +0400
Message-ID: <CAOVevU4BBYrtcLBnC1K3bW3v79k0GPSKpSVd9QKd0vAS9THBtQ_at_mail.gmail.com>



Strictly speaking, hint rule still works even on 12.1, but it is not supported since 10.1

Best regards,
Sayan Malakshinov
Senior Oracle performance tuning engineer PSBANK
http://orasql.org
30.03.2014 21:38 пользователь "Kim Berg Hansen" <kibeha_at_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-l
Received on Sun Mar 30 2014 - 20:05:25 CEST

Original text of this message