Re: The Oracle 9.2.0.4 Optimizer - are there problems with it?
- From: Paul Drake <discgolfdba@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 2 Apr 2004 14:35:30 -0800 (PST)
--- "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 //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
