Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Oracle 10g upgrade - performance issue

Oracle 10g upgrade - performance issue

From: Peter Dixon <peterdixon001_at_hotmail.com>
Date: Tue, 11 Jul 2006 17:43:18 +0000
Message-ID: <BAY101-F350A0A2B8F3F69C68D7C07FC680@phx.gbl> 





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


Received on Tue Jul 11 2006 - 12:43:18 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US