|
Reactive SQL tuning? Sure, It’s been around awhile and is a solid SQL tuning strategy. The problem is, with reactive SQL tuning you take action AFTER a problem occurs. What you need is a way to anticipate a problem BEFORE it becomes a problem – predicting and solving SQL issues rather than reacting after the fact.
Predictive SQL tuning is the answer. This strategy anticipates SQL performance problems before they lead to potential widespread downtime in the Oracle database environment. The Quest white paper “Predictive Diagnostics for SQL Performance Tuning in Oracle” outlines an approach for this new SQL tuning strategy, and provides suggestions to mitigate IT costs.
|