Oracle 10g upgrade - performance issue

From: "Peter Dixon" <peterdixon001@xxxxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Date: Tue, 11 Jul 2006 17:43:18 +0000

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

Follow-Ups:

RE: Oracle 10g upgrade - performance issue
From: Igor Neyman

Re: Oracle 10g upgrade - performance issue
From: Alex Gorbachev

Re: Oracle 10g upgrade - performance issue
From: Juan Carlos Reyes Pacheco

Oracle 10g upgrade - performance issue

Other related posts: