Re: DBMS_SPM.LOAD_FROM_CURSOR_CACHE

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Tue, 11 Oct 2011 22:31:04 +0000 (UTC)
Message-ID: <pan.2011.10.11.22.31.02_at_gmail.com>

On Tue, 11 Oct 2011 13:19:27 -0700, Randolf Geist wrote:

> I don't think that you're following the exact procedure outlined - the
> point is that you need to specify either a SQL_HANDLE of an already
> existing baseline or a SQL_TEXT of the unhinted SQL in addition to which
> you want to apply the plan of the hinted query. So the SQL_ID and
> PLAN_HASH_VALUE refer to the hinted query but the SQL_HANDLE or SQL_TEXT
> refer to the unhinted version of the query.
>
> Look carefully at the provided examples.
>
> Hope this helps,
> Randolf

Did you try it? Does it work?

-- 
http://mgogala.byethost5.com

Received on Tue Oct 11 2011 - 17:31:04 CDT