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

From: <>
Date: Tue, 20 Jan 2015 06:48:33 -0500
Message-ID: <>


You may want to read up on Kerry and his links - he has some excellent stuff on this topic

- Raj Pande

  1000 Lincoln Harbor, floor 10, Weehawken NJ 07086
  +1 201 352 0441  (19 422 0441)

-----Original Message-----
From: [] On Behalf Of Mladen Gogala Sent: Monday, January 19, 2015 10:08 AM To:
Subject: Re: how can I move from sql profiles to stored outlines?

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 Enterprise Edition database to a
> 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


Please visit our website at for important disclosures and information about our e-mail policies. For your protection, please do not transmit orders or instructions by e-mail or include account numbers, Social Security numbers, credit card numbers, passwords, or other personal information.

Received on Tue Jan 20 2015 - 12:48:33 CET

Original text of this message