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

From: Jonathan Lewis <>
Date: Thu, 27 Mar 2014 07:36:36 +0000
Message-ID: <CE70217733273F49A8A162EE074F64D901DE61EF_at_exmbx05.thus.corp>

There are some problems with changes in implementation and meaning, though, e.g:

push_subq in the main body used to push all subqueries, now it doesn't work unless you specify which query block it applies to or put the hint in the query block use_concat() doesn't always work as it used to - some cases of concatentation have turned into in-list iteration ordered is dangerous since changes in unnesting and view merging may mean that the transformed statement has its tables in an order in it from clause that you weren't expected

There are various "deprecated" hints listed in the upgrade manuals - I haven't tested whether any of them simply don't work (properly) any more, or whether they still work but you shouldn't be using them.

Jonathan Lewis

From: [] on behalf of Niall Litchfield [] Sent: 27 March 2014 07:16
Subject: Re: Oracle 9i hints that are obsolete in 11gR2

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" <<>> 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.

Bheem Aitha

Received on Thu Mar 27 2014 - 08:36:36 CET

Original text of this message