Usage of Baselines to prevent plan changes
From: Beckstrom Jeffrey <JBECKSTROM_at_gcrta.org>
Date: Wed, 28 Sep 2016 10:05:19 -0400
Message-Id: <57EB95DF0200000B00018812_at_groupwise2014.gcrta.org>
Over the past year, we have encountered problems where a SQL statement suddenly starts performing badly. In the past, we would either create a SQL Profile or alter the SQL with hints to get the old plan back. Just wondering if people used Baselines to prevent this form occurring and how well they work? This is an Oracle EBS system. If we use Baselines and Oracle changes the table structure adding an index to improve performance, would the new index be ignored because of the Baseline?
Date: Wed, 28 Sep 2016 10:05:19 -0400
Message-Id: <57EB95DF0200000B00018812_at_groupwise2014.gcrta.org>
Over the past year, we have encountered problems where a SQL statement suddenly starts performing badly. In the past, we would either create a SQL Profile or alter the SQL with hints to get the old plan back. Just wondering if people used Baselines to prevent this form occurring and how well they work? This is an Oracle EBS system. If we use Baselines and Oracle changes the table structure adding an index to improve performance, would the new index be ignored because of the Baseline?
Jeffrey Beckstrom
Lead Database Administrator
Information Technology Department
Greater Cleveland Regional Transit Authority
1240 W. 6th Street
Cleveland, Ohio 44113
.
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Sep 28 2016 - 16:05:19 CEST