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
--
//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
Other related posts:
