Re: moving 10g execution plan to 11g using SPM
From: Ls Cheng <exriscer_at_gmail.com>
Date: Wed, 5 Mar 2014 11:00:53 +0100
Message-ID: <CAJ2-Qb_NRWt73CUZiaN1vCta6V18jn1aN8_0bp=Co0rCe1W=bg_at_mail.gmail.com>
Hi
Date: Wed, 5 Mar 2014 11:00:53 +0100
Message-ID: <CAJ2-Qb_NRWt73CUZiaN1vCta6V18jn1aN8_0bp=Co0rCe1W=bg_at_mail.gmail.com>
Hi
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_at_gmail.com> 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!
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Mar 05 2014 - 11:00:53 CET