Load SQL PLan into SQL Plan Baselines from AWR
From: Marian Bednar <bednar_at_nbs.sk>
Date: Fri, 12 Feb 2016 07:26:10 +0100
Message-ID: <OFF733AEBF.6F395FF7-ONC1257F57.002279DE-C1257F57.00235B20_at_nbs.sk>
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.
Date: Fri, 12 Feb 2016 07:26:10 +0100
Message-ID: <OFF733AEBF.6F395FF7-ONC1257F57.002279DE-C1257F57.00235B20_at_nbs.sk>
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 - 07:26:10 CET