RE: Oracle 9i hints that are obsolete in 11gR2
Date: Thu, 27 Mar 2014 16:28:58 +0800
Message-ID: <0BDF2A25A09ADD40908745EEFC0A0FB6019AEFEE_at_HKJUMXMB103B.zone1.scb.net>
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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Bheemsen Aitha
Sent: Thursday, March 27, 2014 1:42 PM
To: oracle-l_at_freelists.org
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.
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Mar 27 2014 - 09:28:58 CET