Re: Plan change after moving to 10g 10.2.0.3
- From: "Greg Rahn" <greg@xxxxxxxxxxxxxxxxxx>
- To: hrishys@xxxxxxxxxxx
- Date: Thu, 18 Dec 2008 09:37:32 -0800
A good place to start...
http://www.oracle.com/technology/products/bi/db/10g/pdf/twp_bidw_optimizer_10gr2_0208.pdf
On Wed, Dec 17, 2008 at 11:44 PM, hrishy <hrishys@xxxxxxxxxxx> wrote:
> 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,
Greg Rahn
http://structureddata.org
--
//www.freelists.org/webpage/oracle-l
Other related posts:
