| 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: The Oracle 9.2.0.4 Optimizer - are there problems with it?
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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Justin Cave (DDBC)
Sent: Friday, April 02, 2004 2:20 PM
To: oracle-l_at_freelists.org
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
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlReceived on Fri Apr 02 2004 - 15:37:56 CST
-----------------------------------------------------------------
 |
 |