Re: how can I move from sql profiles to stored outlines?

From: Mladen Gogala <mgogala_at_yahoo.com>
Date: Mon, 19 Jan 2015 10:07:54 -0500
Message-ID: <54BD1DCA.1020709_at_yahoo.com>

On 01/19/2015 07:42 AM, Andrea Monti wrote:
> Hi Listers,
>
> I am looking for the most convenient way to build stored outlines from
> sql profiles.
> I realize that this is quite a weird question and I do know that sql
> profiles provide far more benefits than stored outlines; however since
> I will have to move from a 10.2.0.4 Enterprise Edition database to a
> 10.2.0.4 Standard Edition cluster, I will have to fall back to stored
> outlines to provide plan stability.
> thanks for every help
> Regards
> Andrea
>

Andrea, SQL Profiles are specific to DBMS_SQLTUNE and can not be moved to stored outlines. However, the nature of the profile is similar to the nature of the outline: it's a bunch of stored hints. You could create an outline for the statement which has a profile and, at least in theory, the outline should contain the current execution hints. Personally, I have never tried that, but it looks like it's worth a try.

-- 
Mladen Gogala
Oracle DBA
http://mgogala.freehostia.com

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Jan 19 2015 - 16:07:54 CET