RE: The Oracle 9.2.0.4 Optimizer - are there problems with it?
- From: "Wales, Stephen (RTSI)" <Stephen.Wales@xxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 2 Apr 2004 14:41:32 -0700
I'm imagining that a lot of these queries weren't run in test - the main =
concern is the OLTP system and a lot of these queries are evolving as =
they roll the query tool out to the users.
I'm not horribly concerned by it, as the OLTP system is fine and 99% of =
the user queries are going OK. It was curiosity more than anything. As =
the long running queries are brought to my attention, it gives us a =
chance to look at the SQL and try to teach the query writers to use =
better query structure - for example the two from this week have both =
been dropped from running in exceess of 30 minutes to now running in 90 =
seconds for one and 25 seconds for the other - they just need to learn =
to set up there where clauses in such a way to make use of the available =
indexes.
But since I'd seen a few notes on Metalink about it, I figured I'd ask =
here if anyone had seen like behavior before.
Steve
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Justin Cave (DDBC)
Sent: Friday, April 02, 2004 2:20 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: The Oracle 9.2.0.4 Optimizer - are there problems with it?
Did you see this behavior when you applied the patch in dev and test, or =
=3D
is it just showing up in production?
Justin Cave
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC
----------------------------------------------------------------
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:
