RE: The Oracle 9.2.0.4 Optimizer - are there problems with it?
- From: "Justin Cave (DDBC)" <jcave@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 2 Apr 2004 14:19:34 -0700
Did you see this behavior when you applied the patch in dev and test, or =
is it just showing up in production?
Justin Cave
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx =
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Wales, Stephen =
(RTSI)
Sent: Friday, April 02, 2004 2:10 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: The Oracle 9.2.0.4 Optimizer - are there problems with it?
We recently (2 weeks ago) threw the 9.2.0.4 patch onto our production =
=3D
9.2.0.2 databases.
Since that time, users have been complaining about long running queries =
=3D are running even longer. Now I'm sure that part of that is poor =
query =3D structure (I've analyzed and tuned 2 of them this week =
already) but the =3D users want to know why their queries are going so =
slow...
I've seen some notes on Metalink referencing a parameter =3D =
optimizer_features_enable and talk of setting it to 8.1.7 - is this =3D =
worth doing? Anyone got any input on this? Or had similar problems? =
=3D Or know of a solution?
Would appreciate any advice.
Thanks
Steve
----------------------------------------------------------------
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:
