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

  • From: Ls Cheng <exriscer@xxxxxxxxx>
  • To: Mohamed Houri <mohamed.houri@xxxxxxxxx>
  • Date: Wed, 5 Mar 2014 11:00:53 +0100


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 <exriscer@xxxxxxxxx> 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!

Other related posts: