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
.
