Browse oracle-l: This Month's Archive • Main Archive Page • Related posts • Previous by Date • Next by Date

Re: Oracle 10g upgrade - performance issue

From: "Juan Carlos Reyes Pacheco" <juancarlosreyesp@xxxxxxxxx>
To: peterdixon001@xxxxxxxxxxx
Date: Wed, 12 Jul 2006 09:18:55 -0400

Hi Peter,
There are bugs, for example in union all, I had to apply 10.2.0.2 patch, or
you can try to set all optimizer features  to 8.1.74, then 9.2, etc.,
Jhonatan lewis book cost optimizer, includes a list of new hidden parameter,
you can try to disable one by one and see which is causing problems.
One problem I got when moving to from 7 to 9.2, was merge, I had to include
in some complex queries a NO_MERGE hint.
If you are migrating a system having complex, and sometimes not too complex
queries, you must expect problems with some queries.
:)

On 7/11/06, Peter Dixon <peterdixon001@xxxxxxxxxxx> wrote:


Help!

Upgraded 8.1.7.4 to 10g rel 2 smoothly over the weekend. Batch works fine,
but OLTP is causing CPU and disk i/o to max out at 100%, i believe the
optimiser is making bad decisions as my introducing rule hints the problem
has slightly improved. Any ideas as our SR with Oracle says "tune the
code"
also we never got the issues in test.

Peter Dixon


--
http://www.freelists.org/webpage/oracle-l

--
----------------------------------------
http://www.oracleboliviaspecialists.com/

Oracle Certified Profesional 9i 10g
Orace Certified Professional Developer 6i

10 years of experience from Oracle 7 to Oracle10g and developer 6i

References:

Oracle 10g upgrade - performance issue
From: Peter Dixon

Other related posts:

Oracle 10g upgrade - performance issue

RE: Oracle 10g upgrade - performance issue

Re: Oracle 10g upgrade - performance issue

RE: Oracle 10g upgrade - performance issue

Re: Oracle 10g upgrade - performance issue

RE: Oracle 10g upgrade - performance issue

Re: Oracle 10g upgrade - performance issue

RE: Oracle 10g upgrade - performance issue