You were brought to this page based on an internet search
and as a free service to Oracle DBAs.
The text below is an except from the book,
Oracle Performance Firefighting, written by
Craig Shallahamer of
OraPub, Inc.
Figures and tables are not included on this page, only their reference.
To order the book in either print or PDF form, click
here.
©2009, 2010 by Craig Shallahamer. This is copyrighted material.
PleaseOut of respect for those involved in the creation of the book and also for
their familes, we ask you to respect the copyright both in intent and deed. Thank you.
-------------------------------
With the key queuing theory calculations performed and the response-time graph created, we are nearly ready to move on to anticipating the performance improvement impact of our various solutions. However, before we get to that topic, it is important to understand the ways we can alter the users' experience.
When it comes to improving performance, the bottom line is to get out of the elbow of the curve. As I have mentioned, when presenting a response-time curve, even nontechnical audiences quickly grasp that being in the elbow is "bad" and being out of the elbow is "good." Use this intuitiveness to demonstrate-even at a very high level-your performance-improving strategies. This will build confidence in your solutions and also help more effectively rank them.
Tuning Oracle, the application, or the operating system effectively reduces its requirements. For example, instead of a SQL statement consuming 5 seconds of CPU, it now consumes only 2 seconds of CPU. Thinking about the basic utilization formula of requirements divided by capacity, if requirements decrease and capacity remains the same, then the utilization must decrease. The only way to increase the utilization once again is to increase the requirements. One way to do this is to increase the workload; that is, the arrival rate. So, through tuning, we have provided the basic performance-enhancing options of decreased response time, increased throughput, or some combination of both.
©2009, 2010 by Craig Shallahamer. This is copyrighted material.
PleaseOut of respect for those involved in the creation of the book and also for
their familes, we ask you to respect the copyright both in intent and deed. Thank you.
|