RE: Load SQL PLan into SQL Plan Baselines from AWR
Date: Fri, 12 Feb 2016 08:23:54 +0100
Message-ID: <OFEFB0E207.77380F19-ONC1257F57.00273053-C1257F57.0028A426_at_nbs.sk>
yes, I can use dbms_spm and standard method for loading Plan Baselines from AWR is by using SQL Tunning Sets (STS) - but for using STS is required Tunning Pack
therefore I am trying to find another solution I know one solution, load to Plan baselines hinted original query a then fake it -https://jonathanlewis.wordpress.com/2011/01/12/fake-baselines/ but exists any other solution to load directly from awr without manually hinting?
From: "Dimensional DBA" <dimensional.dba_at_comcast.net>
To: <bednar_at_nbs.sk>, "'oracle-l digest users'"
<oracle-l_at_freelists.org>,
Date: 12. 02. 2016 08:04
Subject: RE: Load SQL PLan into SQL Plan Baselines from AWR
The diagnostic pack gives you access to AWR. You can use standard SQL Plan Management as the license is included with the EE database, no extra licensing required.
https://blogs.oracle.com/optimizer/entry/does_the_use_of_sql https://docs.oracle.com/cd/B28359_01/license.111/b28287.pdf https://docs.oracle.com/cd/E11882_01/license.112/e47877.pdf
dbms_outln or dbms_spm.
Matthew Parker
Chief Technologist
Dimensional DBA
425-891-7934 (cell)
D&B 047931344
CAGE 7J5S7
Dimensional.dba_at_comcast.net
View Matthew Parker's profile on LinkedIn
www.dimensionaldba.com
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Marian Bednar
Sent: Thursday, February 11, 2016 10:26 PM
To: oracle-l digest users
Subject: Load SQL PLan into SQL Plan Baselines from AWR
Oracle 11.2.0.4
I need to load good sql plan into SQL PLan Baselines from AWR.
But I have only Diagnostic Pack License, so I cannot use SQL Tuning Set .
Exists any other method to load from AWR?
In v$sql_plan exist only "bad plans".
Thanks.
Marian
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Feb 12 2016 - 08:23:54 CET