Re: moving 10g execution plan to 11g using SPM

SPM is not very verbose when it comes to not reproducing a plan. Where I can help you with is identifying the reason of the regressions you are observing. What I would need is between 1 and 3 of such regressions, and have SQLT XTRACT (MOS 215187.1) executed for each of those SQL_IDs in both the 10.2.0.5 and the 11.2.0.4 environments.

Cheers,

Carlos Sierra

blog: carlos-sierra.net
twitter: _at_csierra_usa

Life's Good!

On Mar 4, 2014, at 6:00 AM, Ls Cheng <exriscer_at_gmail.com> wrote:

> Hi all
>
> I am currently upgrading a few databases from 10.2.0.5 to 11.2.0.4 and running SQL regression tests using SQL Performance Analyzer, I have detected a few queries that is not performing well in 11g so I transported those queries execution plan and imported as sql plan baselines in 11g. The strange thing is that these base lines are not used, after running SPM tracing I see that it cannot reproduce the execution plan (SPM: failed to reproduce the plan using the following info: is shown in the trace files) but I cannot see the reasoning. The possibilities I can think of is schema differences between 10g and 11g, object mapping is different or outline errors but these dont seem apply or at least not observed in SPM trace and 10053 trace.
>
> Does anyone know what other potential reasons can cause such behaviour?
>
>
> Thanks
>

--
http://www.freelists.org/webpage/oracle-l