RE: Load SQL PLan into SQL Plan Baselines from AWR

From: Marian Bednar <>
Date: Fri, 12 Feb 2016 08:23:54 +0100
Message-ID: <>

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 - but exists any other solution to load directly from awr without manually hinting?

From: "Dimensional DBA" <> To: <>, "'oracle-l digest users'" <>,
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.

dbms_outln or dbms_spm.    

Matthew Parker
Chief Technologist
Dimensional DBA
425-891-7934 (cell)
D&B 047931344
View Matthew Parker's profile on LinkedIn    

From: [] 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  

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".


Received on Fri Feb 12 2016 - 08:23:54 CET

Original text of this message