Re: Plan change after moving to 10g

From: Greg Rahn <>
Date: Thu, 18 Dec 2008 09:37:32 -0800
Message-ID: <>

A good place to start...

On Wed, Dec 17, 2008 at 11:44 PM, hrishy <> 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
> 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.

Greg Rahn
Received on Thu Dec 18 2008 - 11:37:32 CST

Original text of this message