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.
-------------------------------
When we perform an ORTA, we classify all IO time as queue time subclassification. This may seem like an unfortunate and desperate abstraction, but it actually fits perfectly from a database perspective. If no IO occurs, Oracle satisfies all requests consuming only CPU time. But as the workload increases and some of this work requires IO, response time begins to increase; that is, queue time begins to increase; that is, IO time begins to increase. The pattern fits very nicely into an ORTA.
In summary, both our CPU service time and IO queue time abstractions fit very nicely into an ORTA, providing us with the opportunity to apply predictive mathematics to evaluate alternative firefighting solutions.
The classic response-time curve in Figure 9-8 highlights the differences between CPU and IO subsystems. It turns out that real Oracle systems operate somewhere between the two. The dotted line in Figure 9-8 represents an Oracle system that operates completely and only with CPU. In others words, there is no physical IO, only logical IO activity. In contrast, the solid line represents an IO-centric Oracle system. No Oracle system can operate with only IO, because there must be CPU resources consumed to run processes, which includes processing the IO once it has been read from disk.
©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.
|