From: Mladen Gogala <>
Date: Tue, 11 Oct 2011 22:31:04 +0000 (UTC)
Message-ID: <>

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?

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

Original text of this message