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@xxxxxxxxxxx>
To: <bednar@xxxxxx>, "'oracle-l digest users'"
<oracle-l@xxxxxxxxxxxxx>,
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.
http://www.oracle.com/technetwork/database/bi-datawarehousing/twp-sql-plan-management-11gr2-133099.pdf
Matthew Parker
Chief Technologist
Dimensional DBA
425-891-7934 (cell)
D&B 047931344
CAGE 7J5S7
Dimensional.dba@xxxxxxxxxxx
View Matthew Parker's profile on LinkedIn
www.dimensionaldba.com
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] ;
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