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@(protected)
[mailto:oracle-l-bounce@(protected)]On Behalf Of Loughmiller, Greg
Sent: Friday, July 09, 2004 8:19 AM
To: 'oracle-l@(protected) '
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@(protected)
put 'unsubscribe ' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://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@(protected)
put 'unsubscribe ' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
