RE: Load SQL PLan into SQL Plan Baselines from AWR

From: Dimensional DBA <>
Date: Thu, 11 Feb 2016 23:04:32 -0800
Message-ID: <054901d16563$a0474cd0$e0d5e670$>

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. anagement-11gr2-133099.pdf    

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:04:32 CET

Original text of this message