SQL Profile and baseline
From: Hameed, Amir <amir.hameed_at_sleepnumber.com>
Date: Tue, 1 Feb 2022 18:06:14 +0000
Message-ID: <CH0PR14MB50127F8DE1014A8DCA0557A3E0269_at_CH0PR14MB5012.namprd14.prod.outlook.com>
Hi,
As a general guideline, once a SQL profile provides an optimal execution plan for a SQL, is it okay to create a baseline for that SQL and then drop the SQL Profile? The DB version is 11.2.0.4. Any feedback will be appreciated.
Date: Tue, 1 Feb 2022 18:06:14 +0000
Message-ID: <CH0PR14MB50127F8DE1014A8DCA0557A3E0269_at_CH0PR14MB5012.namprd14.prod.outlook.com>
Hi,
As a general guideline, once a SQL profile provides an optimal execution plan for a SQL, is it okay to create a baseline for that SQL and then drop the SQL Profile? The DB version is 11.2.0.4. Any feedback will be appreciated.
Thanks,
Amir
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Feb 01 2022 - 19:06:14 CET