RE: how can I move from sql profiles to stored outlines?
- From: <rajendra.pande@xxxxxxx>
- To: <dmarc-noreply@xxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 20 Jan 2015 06:48:33 -0500
Andrea
You may want to read up on Kerry and his links - he has some excellent stuff on
this topic
http://kerryosborne.oracle-guy.com/2009/04/oracle-sql-profiles/
Regards
- Raj Pande
UBS AG
CORE ENG PLATFORM AS A SERVICE (PAAS)
1000 Lincoln Harbor, floor 10, Weehawken NJ 07086
+1 201 352 0441 (19 422 0441)
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Mladen Gogala
Sent: Monday, January 19, 2015 10:08 AM
To: oracle-l@xxxxxxxxxxxxx
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 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
--
//www.freelists.org/webpage/oracle-l
Please visit our website at
http://financialservicesinc.ubs.com/wealth/E-maildisclaimer.html
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.
Other related posts:
