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

Home -> Community -> Usenet -> c.d.o.server -> SQL Queries SLOW after Oracle 8i to 10g migration

SQL Queries SLOW after Oracle 8i to 10g migration

From: Blue Crystal Solutions <vito.rinaldi_at_bluecrystal.com.au>
Date: 29 Aug 2005 19:13:42 -0700
Message-ID: <1125368022.008814.161250@f14g2000cwb.googlegroups.com> 






I have just migrated from Oracle 8i to Oracle 10g on a Windows 2003
server. The server is of higher processing power. Several SQL Queries,
some complex ones are very slow.



Some SQL Queries run faster and some queries run slower.
Some queries used to run in 6 minutes now take up to 6 hours. Some
queries run faster.


The indexes are exactly the same in both versions.
What has changed in the optimizer when upgrading from 8i to 10G?
What needs to be done for these queries? And why?
Received on Mon Aug 29 2005 - 21:13:42 CDT












Original text of this message













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