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

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Thu, 27 Mar 2014 07:16:49 +0000
Message-ID: <CABe10sZXvMtL0jkYu4kF+N5+wgc+AkeLcvkRScidRJ_ifrNxJw_at_mail.gmail.com>

Hi Bheem I am not aware of any the are obsolete ( meaning removed) . It is possible to argue that the RULE hint is obsolete, but I think it still has effect. What you may find if course is that the optimizer has more options available to it which might mean either

1. your hinted sql follows a different plan than in 9
2. you miss out on some enhanced behaviour because your hints preclude it. On 27 Mar 2014 05:43, "Bheemsen Aitha" <baitha_at_itradenetwork.com> wrote:

> Hi all~
>
>
>
> We are in the process of upgrading our database from 9i to 11gR2 on
> Solaris SPARC 64-bit platform. I was wondering if anyone knows a list of
> oracle hints that will not work anymore in 11gR2 and that used to work in
> 9i. I know that there are whole lot of new hints introduced in 11gR2, but I
> could not find a list of obsolete/deprecated hints from 9i to 11gR2.
>
>
>
> Any pointers is appreciated.
>
>
>
> Thanks
>
> *Bheem Aitha*
>
>
>

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

Received on Thu Mar 27 2014 - 08:16:49 CET