Re: The Oracle 9.2.0.4 Optimizer - are there problems with it?

From: Paul Drake <discgolfdba_at_yahoo.com>
Date: Fri, 2 Apr 2004 14:35:30 -0800 (PST)
Message-ID: <20040402223530.24824.qmail@web20413.mail.yahoo.com>

• "Wales, Stephen (RTSI)" <Stephen.Wales_at_riotinto.com> wrote:
  > We recently (2 weeks ago) threw the 9.2.0.4 patch
  > onto our production =
  > 9.2.0.2 databases.
  

> Since that time, users have been complaining about
> long running queries =

> Would appreciate any advice.

> Thanks
> Steve

Steve,

obvious reply:
dump a 10053 and 10046 trace of the executions of the statements in both environments and compare the execution plans.
the 10053 is especially good for dumping all of the parameters that affect the CBO, even if you don't want to read the entire trace file.

then you can post the relevant sections here and others much more knowledgeable than I can offer their opinions.

went thru that fun with 8.1.7.4 to 9.2.0.4. not looking forward to doing it again with 9.2.0.4 to 10.1.x.

Paul

---

Do you Yahoo!?
Yahoo! Small Business $15K Web Design Giveaway http://promotions.yahoo.com/design_giveaway/

---

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 Apr 02 2004 - 16:31:53 CST