Re: Risk of RULE mode in 10g+
- From: s.cislaghi@xxxxxxxxx
- To: zollarja@xxxxxxxxx,oracle-l@xxxxxxxxxxxxx
- Date: Mon, 15 Mar 2010 20:10:21 +0000
There's no risk as far as I know. We have a customer in a similar situation
reported from you with a 10.2.0.4 installation with no problem.
I may suggest you also to try to run you apps with CBO and check if you
experience any real problem. Also if you have a license you can also use Sql
advisor and Sql tuning to gain needed performances.
Ste
--
http://www.stefanocislaghi.eu
Sent by BlackBerry®
-----Original Message-----
From: Jeffrey Zollars <zollarja@xxxxxxxxx>
Date: Mon, 15 Mar 2010 12:21:53
To: <oracle-l@xxxxxxxxxxxxx>
Subject: Risk of RULE mode in 10g+
We are upgrading an application to the current version and also upgrading
the DB version from 9i to 10g. The application code has several bits of code
that are explicitly setting RULE mode. One in a configuration table that can
be updated. Second, in several hints coded in SQL statements which cannot be
easily changed.
I have provided Oracle documentation to the application vendor showing that
RULE mode is desupported in 10g+ versions. They were skeptical to say the
least.
I had thought that I'd seen stronger warnings that RULE mode could actually
generate incorrect result sets when running queries. I have searched but
could not find those warnings now. I am trying to make a case to request the
application vendor to go back and modify the code before we update to the
current version of the application on Oracle 10.2.0.4 version. I'm concerned
about the integrity of the result sets.
I am wondering if anyone knows of or can provide a link to the warning that
result sets may be incorrect in 10g+ using RULE mode.
Thanks,
Jeff
--
J. A. Zollars
ZollarJA@xxxxxxxxx
Other related posts:
