| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Have you had any issues with 9.2.0.5
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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Loughmiller, Greg
Sent: Friday, July 09, 2004 8:19 AM
To: 'oracle-l_at_freelists.org'
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
-- 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_at_freelists.org 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 -----------------------------------------------------------------Received on Fri Jul 09 2004 - 09:15:57 CDT
 |
 |