 |
 |
 |
|
Oracle performance analysis has come a long way in the last 20 years. First there was the “just add more resources” approach and tuning the blatantly poor SQL. Then there was ratio analysis followed by wait event analysis. Finally, response time analysis (RTA), in a way, closed the loop. What is so key about RTA is that it brought together and detailed the two elements of response time, that is, service time and queue time. But over the past couple of years, while DBAs talk about Oracle timing and response time analysis, for the most part, the focus rests solely on the wait interface. And this unhealthy focus on the wait interface is where the modern performance myths lie in wait…
The four myths are:
Myth #1. Decreasing wait event time will always decrease Oracle response time.
Myth #2. Decreasing wait event time will always decrease end-to-end response time.
Myth #3. Profiling sessions is the best way to diagnose performance problems.
Myth #4. Focusing on where most of the time is spent is always the best approach. |
|
|
|
|
|
|
