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

From: Carlos Sierra <>
Date: Tue, 4 Mar 2014 06:09:25 -0600
Message-Id: <>


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 and the environments.


Carlos Sierra

twitter: _at_csierra_usa

Life's Good!

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

> Hi all
> I am currently upgrading a few databases from to 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

Received on Tue Mar 04 2014 - 13:09:25 CET

Original text of this message