Re: Plan change after moving to 10g 10.2.0.3
- From: "Jack van Zanen" <jack@xxxxxxxxxxxx>
- To: hrishys@xxxxxxxxxxx
- Date: Thu, 18 Dec 2008 22:31:04 +1100
There are some differences in the way dbms_stats works between the two
versions (default settings are different) that you may want to look into.
There are quite a few doco's regarding performance issues after upgrade,
just search metalink for them
Jack
2008/12/18 hrishy <hrishys@xxxxxxxxxxx>
> Hi
>
> I have a very simple query (which i should be able to post after i have
> acesses to it) where the plan has changed NL using a index to Hash join on a
> simple two table join after migrating to 10.2.0.3.
>
> My question is
> Has anybody encountered such a situation after migarting from 9i to 10g RAC
> ?
> Will oracle support guys help me if i give them the good and the bad plans
> and the 10053 traces ? (is this covered as part of metalink support
> contract)
>
> I am clueless on how come a simpel two table join with no partitioning a
> query could go bad.
>
> regards
> Hrishy
>
> One solution is to resorting to hints which i dont want to in this case as
> it is ugly.
>
>
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
J.A. van Zanen
Other related posts: