RE: Have you had any issues with 9.2.0.5
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 9 Jul 2004 10:18:48 -0400
I have an issue where if you define a view that contains a UNION of
two queries, and each of the queries contains an analytical function,
then the predicate is not pushed into the view, resulting in a
non-optimal execution plan.
It works in 8.1.7.4 and breaks in 9.2.0.5 and 10.1.0.2.
I have a small,concise testcase. If anyone wants to play with it,
I can post it.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Loughmiller, Greg
Sent: Friday, July 09, 2004 8:19 AM
To: 'oracle-l@xxxxxxxxxxxxx'
Subject: Have you had any issues with 9.2.0.5
Folks,
=20
If you all could be so kind, could you please share any negative =
experience
that you all have had by using 9205? Specifically, any bugs/issues that =
you
have encountered while using 9.2.0.5. So for example, Raj had mentioned =
that
he had encountered issues with the "decode" and "cursor_sharing".
In addition, for those who are using Oracle Apps and 9205 would be of
special interest.
=20
Oh, I forgot to mention that this is just one channel of resources =
(rtfm,
google, metalink, oracle support, forums, etc) I'm chasing for this info =
:-)
Thanks in advance....=20
=20
=20
Greg Loughmiller
Sr Manager - Enterprise Data Architecture
Office: 678.893.3217
ips: gloughmiller
This email, and any attachments, are intended only for use by the
addressee(s) named herein and may contain legally privileged and/or
confidential information. It is the property of Cingular Wireless. If =
you
are not the intended recipient of this email, you are hereby notified =
that
any dissemination, distribution or copying of this email, any =
attachments
thereto, and any use of the information contained is strictly =
prohibited. If
you have received this email in error, please notify me at 678-893-3217 =
and
permanently delete the original and any copy thereof.
=20
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
