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

  • From: "Chitale, Hemant K" <Hemant-K.Chitale@xxxxxx>
  • To: <baitha@xxxxxxxxxxxxxxxxx>
  • Date: Thu, 27 Mar 2014 16:28:58 +0800

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: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Bheemsen Aitha
Sent: Thursday, March 27, 2014 1:42 PM
To: oracle-l@xxxxxxxxxxxxx
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.

 

Thanks

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 
https://www.sc.com/en/incorporation-details.html.

Other related posts: