Re: SQL Queries SLOW after Oracle 8i to 10g migration

Blue Crystal Solutions apparently said,on my timestamp of 30/08/2005 12:13 PM:

> 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?

If all else recommended in the manuals fails (running traces, making sure the stats are gathered the right way, checking the obvious parameters), you can always set the optimizer back to 8i compatibility and live with it, no?

-- 
Cheers
Nuno Souto
in sunny Sydney, Australia
wizofoz2k_at_yahoo.com.au.nospam