Hi Peter,
There are bugs, for example in union all, I had to apply 10.2.0.2 patch, or
you can try to set all optimizer features to 8.1.74, then 9.2, etc.,
Jhonatan lewis book cost optimizer, includes a list of new hidden parameter,
you can try to disable one by one and see which is causing problems.
One problem I got when moving to from 7 to 9.2, was merge, I had to include
in some complex queries a NO_MERGE hint.
If you are migrating a system having complex, and sometimes not too complex
queries, you must expect problems with some queries.
:)
On 7/11/06, Peter Dixon <peterdixon001_at_hotmail.com> wrote:
>
> 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
>
>
>
--
----------------------------------------
http://www.oracleboliviaspecialists.com/
Oracle Certified Profesional 9i 10g
Orace Certified Professional Developer 6i
10 years of experience from Oracle 7 to Oracle10g and developer 6i
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jul 12 2006 - 08:18:55 CDT
