moving 10g execution plan to 11g using SPM

From: Ls Cheng <>
Date: Tue, 4 Mar 2014 13:00:44 +0100
Message-ID: <>

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?


Received on Tue Mar 04 2014 - 13:00:44 CET

Original text of this message