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

--- "Wales, Stephen (RTSI)"
<Stephen.Wales@xxxxxxxxxxxx> 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@xxxxxxxxxxxxx
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
-----------------------------------------------------------------

Other related posts: