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

From: Chitale, Hemant K <>
Date: Thu, 27 Mar 2014 16:28:58 +0800
Message-ID: <>

I suggest that you go through the SQL Language Reference Manual documentation on Hints in 11.2  

The PARALLEL / NO_PARALLEL Hint has certainly changed from 10g to 11gR2. Other hints might have changed. I haven’t heard of Hints being dropped, but behaviour can change.  

Hemant K Chitale    

From: [] On Behalf Of Bheemsen Aitha Sent: Thursday, March 27, 2014 1:42 PM
Subject: Oracle 9i hints that are obsolete in 11gR2  

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  

This email and any attachments are confidential and may also be privileged. If you are not the intended recipient, please delete all copies and notify the sender immediately. You may wish to refer to the incorporation details of Standard Chartered PLC, Standard Chartered Bank and their subsidiaries at

Received on Thu Mar 27 2014 - 09:28:58 CET

Original text of this message