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:22 -0700
Message-ID: <1125368002.868785.119440@g43g2000cwa.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:22 CDT