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

From: Ls Cheng <>
Date: Wed, 5 Mar 2014 11:00:53 +0100
Message-ID: <>


After investigating a bit more......

It was NOT DBMS_SQLPA problem, the problem is NLS_LANG is different in 11g, once I put same NLS_LANG as 10g the query works fine and picks up the SQL Plan Baseline.

It looks like SQL Plan Baselines are associated to NLS_LANG settings?

On Tue, Mar 4, 2014 at 3:49 PM, Ls Cheng <> wrote:

> Found the problem, it seems that running from DBMS_SQLPA baseline cannot
> be used for some reason, when running the query manually the baseline is
> picked up!

Received on Wed Mar 05 2014 - 11:00:53 CET

Original text of this message